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!

ERROR:SRW Packages to call report from PL/SQL.

719826Aug 28 2009
Hi,
I am facing the following problem while calling a report from PL/SQL Block.

This is my code

SRW.Start_Debugging;
MYPLIST :=SRW_PARAMLIST(SRW_PARAMETER('',''));
SRW.ADD_PARAMETER(myPlist,'GATEWAY' ,'http:..............');
SRW.ADD_PARAMETER(myPlist,'USERID' ,'CGIA_AUTO/AUTO_DEV@ipaddress/ORCL');
SRW.ADD_PARAMETER(myPlist,'SERVER' ,'rep_cgian');
SRW.ADD_PARAMETER(myPlist,'REPORT' ,'PGIRCGIC047.rdf');
SRW.ADD_PARAMETER(myPlist,'DESTYPE' ,'file');
SRW.ADD_PARAMETER(myPlist,'DESFORMAT' ,'pdf');
SRW.ADD_PARAMETER(myPlist,'DESNAME' ,'\\ipaddress\CGIA_FormPrint\WatchFolder\OTHERS\'||Z.CS_REMARKS_BL||'_'||Z.CS_CHQ_NO||'_'||M_SEQ_NO||'-'||Z.CS_FLEX_07||'-'||Z.CS_FLEX_08||'.pdf');
SRW.ADD_PARAMETER(myPlist,'PARAMFORM' ,'NO');
SRW.ADD_PARAMETER(myPlist,'P_1' ,Z.CS_BANK_CODE);
SRW.ADD_PARAMETER(myPlist,'P_2' ,Z.CS_BAD_ACNT_NO);
SRW.ADD_PARAMETER(myPlist,'P_3' ,Z.CS_CHQ_BOOK_ID);
SRW.ADD_PARAMETER(myPlist,'P_4' ,Z.CS_CHQ_NO);
SRW.ADD_PARAMETER(myPlist,'P_5' ,Z.CS_CHQ_NO);
MYIDENT:=SRW.RUN_REPORT(MYPLIST);
MYSTATUS := SRW.REPORT_STATUS(MYIDENT);
SRW.STOP_DEBUGGING;
------------------------------------------------------------------------------------------------------------
*** Length of Paramlist : 1
OK : Parameter added : GATEWAY=http://...
*** Length of Paramlist : 2
OK : Parameter added : USERID=CGIA_AUTO/AUTO_DEV@ipaddress/ORCL
*** Length of Paramlist : 3
OK : Parameter added : SERVER=rep_cgian
*** Length of Paramlist : 4
OK : Parameter added : REPORT=PGIRCGIC047.rdf
*** Length of Paramlist : 5
OK : Parameter added : DESTYPE=file
*** Length of Paramlist : 6
OK : Parameter added : DESFORMAT=pdf
*** Length of Paramlist : 7
OK : Parameter added :
DESNAME=\\ipaddress\CGIA_FormPrint\WatchFolder\OTHERS\CUST000115_102024_16--.pd
f
*** Length of Paramlist : 8
OK : Parameter added : PARAMFORM=NO
*** Length of Paramlist : 9
OK : Parameter added : P_1=SDNB
*** Length of Paramlist : 10
OK : Parameter added : P_2=7000674257
*** Length of Paramlist : 11
OK : Parameter added : P_3=7000
*** Length of Paramlist : 12
OK : Parameter added : P_4=102024
*** Length of Paramlist : 13
OK : Parameter added : P_5=102024
Starting run_report: building url
*** Building URL (RUN_REPORT)
OK : URL built :
http://ipaddress/reports/rwservlet?&USERID=CGIA_AUTO%2FAUTO_DEV%40ipaddress%2FORCL&SERVER=rep_cgian&REPORT=PGIRCGIC047.rdf&DESTYPE=file&DESFORMAT=
pdf&DESNAME=%5C%5Cipaddress%5CCGIA_FormPrint%5CWatchFolder%5COTHERS%5CCUST00
*** Submitting HTTP Request
*** using URL
:http://ipaddress/reports/rwservlet?&USERID=CGIA_AUTO%2FAUTO_DEV%ORCL&SERVER=rep_cgian&REPORT=PGIRCGIC047.rdf&DESTYPE=file&DESFORMAT
=pdf&DESNAME=%5C%5Cipaddress%5CCGIA_FormPrint%5CWatchFolder%5COTHERS%5CCUST0001
OK : Request submitted - Return stream : <?xml version = '1.0' encoding =
'ISO-8859-1' standalone = 'yes'?>

<serverQueues>

<error code="503"
component="REP" message="You did not specify the name of a
report."/>

</serverQueues>

------------------------------------------------------------------------------------------------------------

Here in this case even though i specify the report id in the parameter,debugger message says that 'You did not specify the name'.

The same code is working in some other server and giving the pdf output.

Thanks in advance for any clarification.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2009
Added on Aug 28 2009
0 comments
1,253 views