Error attempting to call report server from pl/sql
I have followed this doc: Event-Driven Publishing using Database Trigger in Reports 9i/10g/11g (Doc ID 199743.1)
And successfully installed the SRW package by correcting the script name and remove the two error lines (solution found on another doc). Now I am getting ORA-06512 error on SRW package line 805. I read that SRW does not support https but I have tried both http and https without success. I am hoping someone here can help, thanks in advance.
Forms and Reports Server 12.2.1.2
Database 19.x
Executing code from same owner that owns SRW package.
Code:
exec srw.start_debugging;
DECLARE
myPlist SRW_PARAMLIST;
myIdent SRW.Job_Ident;
BEGIN
dbms_output.put_line('starting');
SRW.clear_parameter_list(myPlist);
myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
srw.add_parameter(myPlist,'GATEWAY','https://<server>.com:9001/reports/rwservlet');
srw.add_parameter(myPlist,'SERVER','<rep_servername>');
srw.add_parameter(myPlist,'REPORT','<report name>');
srw.add_parameter(myPlist,'USERID','<user/pword@db>');
srw.add_parameter(myPlist,'AUTHID','<user/pword@db>');
srw.add_parameter(myPlist,'DESTYPE','CACHE');
srw.add_parameter(myPlist,'DESFORMAT','DELIMITEDDATA');
myIdent := srw.run_report(myPlist);
dbms_output.put_line('it worked');
EXCEPTION
when others then
raise;
END;
/
exec srw.stop_debugging;
DBMS OUTPUT
***************************************
* WELCOME TO EVENT-BASED-REPORTING API *
* API-Version : 9i *
* (C) Oracle Corporation, 2000 - 2002 *
*
* Debugging turned ON **************************
starting
*** Parameter-list cleared
*** Length of Paramlist : 1
OK : Parameter added : GATEWAY=https://<server>.com:9001/reports/rwservlet
*** Length of Paramlist : 2
OK : Parameter added : SERVER=<rep servername>
*** Length of Paramlist : 3
OK : Parameter added : REPORT=<report>
*** Length of Paramlist : 4
OK : Parameter added : USERID=<user/pword@db>
*** Length of Paramlist : 5
OK : Parameter added : AUTHID=<user/pword@db>
*** Length of Paramlist : 6
OK : Parameter added : DESTYPE=CACHE
*** Length of Paramlist