Skip to Main Content

DevOps, CI/CD and Automation

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!

Not able to schedule oracle reports through oracle enterprise manager

852593Feb 15 2018 — edited Mar 2 2018

Hi,

    

     I am not able to schedule oracle reports throught oracle enterprise manager, I used below code but it not works, it shows error like ,Please help i am new in oracle forms and reports as well for oracle enterprise manager, please help...

ORA-06550: line 2, column 9: PLS-00201: identifier 'SRW_PARAMLIST' must be declared ORA-06550: line 2, column 9: PL/SQL: Item ignored ORA-06550: line 3, column 9: PLS-00201: identifier 'SRW.JOB_IDENT' must be declared.

code used:

declare
myPlist SRW_PARAMLIST;
myIdent SRW.Job_Ident;
BEGIN
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
SRW.ADD_PARAMETER(myPlist,'GATEWAY','http://late:1002/reports/rwservlet');
SRW.ADD_PARAMETER(myPlist,'SERVER','late');
SRW.ADD_PARAMETER(myPlist,'REPORT','e:\erp\reportdone\quotation.rdf');
SRW.ADD_PARAMETER(myPlist,'USERID','scott/tiger');
SRW.ADD_PARAMETER(myPlist,'DESTYPE','FILE');
SRW.ADD_PARAMETER(myPlist,'DESTINATION','e:\workflow\sushmapatch.pdf');
SRW.ADD_PARAMETER(myPlist,'vcompany','badlapur(2017-2018)');
SRW.ADD_PARAMETER(myPlist,'vdocno',1);
SRW.ADD_PARAMETER(myPlist,'vlocation','Badlapur');
myIdent := SRW.RUN_REPORT(myPlist);
END;

   

Thanks & Regards,

    Sushma

This post has been answered by Matej D. on Feb 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2018
Added on Feb 15 2018
42 comments
2,677 views