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