DevOps, CI/CD and Automation

I get a user defined exception in the SRW package, but without an error message. So I have no clue what is wrong. This is the code (in DB 9.2.0.8)

DECLARE
myPlist SRW_PARAMLIST;
myIdent SRW.Job_Ident;
myStatus SRW.Status_Record;
BEGIN
srw.start_debugging;
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
srw.add_parameter(myPlist,'GATEWAY','http://server:port/reports/rwservlet');
srw.add_parameter(myPlist,'REPORT','report.rdf');
srw.add_parameter(myPlist,'DESTYPE','cache');
srw.add_parameter(myPlist,'DESFORMAT','pdf');
srw.add_parameter(myPlist,'PARAMFORM','no');
srw.add_parameter(myPlist,'USERID','un/pw@db');
srw.add_parameter(myPlist,'p_param1','value');
myIdent := srw.run_report(myPlist);
myStatus := srw.report_status(myIdent);
srw.stop_debugging;
END;

The output is:

****************************************
* WELCOME TO EVENT-BASED-REPORTING API *
* API-Version : 9i *
* (C) Oracle Corporation, 2000 - 2002 *
*
* Debugging turned ON **************************
*** Length of Paramlist : 1
OK : Parameter added : GATEWAY=http://server:port/reports/rwservlet
*** Length of Paramlist : 2
OK : Parameter added : REPORT=report.rdf
*** Length of Paramlist : 3
OK : Parameter added : DESTYPE=cache
*** Length of Paramlist : 4
OK : Parameter added : DESFORMAT=pdf
*** Length of Paramlist : 5
OK : Parameter added : PARAMFORM=no
*** Length of Paramlist : 6
OK : Parameter added : USERID=un/pw@db
*** Length of Paramlist : 7
OK : Parameter added : P_PARAM1=value
Starting run_report: building url
*** Building URL (RUN_REPORT)
DECLARE
*
ERROR at line 1:
ORA-20004:
ORA-06512: at "PROD.SRW", line 463
ORA-06512: at "PROD.SRW", line 543
ORA-06512: at "PROD.SRW", line 790
ORA-06512: at line 18


I know I can contact the report server from the database, since this works:

declare
req utl_http.req;
resp utl_http.resp;
begin
req := utl_http.begin_request('http://....');
resp := utl_http.get_response(req);
dbms_output.put_line('HTTP response status code: ' || resp.status_code);
dbms_output.put_line('HTTP response reason phrase: ' || resp.reason_phrase);
utl_http.end_response(resp);
end;

(where the request is of course the actual URL to call the report)

Message was edited by:
Ino Laurensse