Oracle Reports (MOSC)

MOSC Banner

Error attempting to call report server from pl/sql

in Oracle Reports (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center