Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to call a report from a form

Mark1970Apr 3 2012 — edited Apr 5 2012
I've created a report with Oracle Reports 10g and saved as MYREPORT.JSP and as MYREPORT.RDF
Than I've created a form and a button with a trigger when-button-pressed with this code:

declare

repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);

begin

repid := FIND_REPORT_OBJECT('D:\ORAFORMS\MYREPORT.JSP');
v_rep := RUN_REPORT_OBJECT(repid);

end;

If I run the form and then click the button created, instead of running the report, I get this message:
FRM-41219: Cannot find report: invalid ID

I use local OC4J Instance

Can you help me?
Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2012
Added on Apr 3 2012
20 comments
1,797 views