Can’t operate Oracle Reports 10g from a form called by another form on the application server

70 pts.
Tags:
Oracle 10g
Oracle 10g administration
Oracle Application Server
Oracle Forms 10g
Oracle Reports 10g
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following