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