i have a form c that operates a report report1 by using the following code:

declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20); BEGIN    repid := FIND_REPORT_OBJECT('REPORT1');

     if :global.struc_code=51 then

 SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'p_year='||:yy||' paramform=no');             SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms');  SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'htmlcss');  v_rep := RUN_REPORT_OBJECT(repid);  rep_status := REPORT_OBJECT_STATUS(v_rep);  WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')  LOOP       rep_status := report_object_status(v_rep);    END LOOP;    IF rep_status = 'FINISHED' THEN       /*Display report*/    WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)|| '?destype=cache&desformat=pdf/html&server=' || 'rep_app_oracle_forms', '_blank');  ELSE     message('Error...');  END IF;    else   null;    END;

- i've copied the exe file of form c to the application server and run the form without problems by using the following url :

http://app.nepco.com.jo:7779/forms/frmservlet?config=app1

app1 points to the form c .

- the problem is if i run form c from a calling form b and called both c,b from the main form (login form) x by the same url above but app1 points to form x the report dosen't run and an error message appears "cant operate the report" and when button ok is pressed another message appears "when_button_pressed trigger raised unhandled exception ora-06502" .

- i want to inform you that i thought the problem relates is related to the lose of logon ,may  be we need to modify a report configuration file the make the ssmode=false to avoid the application server authetication but i don't know how nor if my thoughts are true .

i need you help please



Software/Hardware used:
oracle application serevr 10g