SRW Report Writer Package 12c
Hello,
I have installed SRW package on our 12c database as per the installation instruction provided in the MOS # shown below.
Event-Driven Publishing using Database Trigger in Reports 9i/10g/11g/12c (Doc ID 199743.1)
The implementation is successfully done. SRW package has been installed using SYS/SYSDBA account and all privileges have been granted to other non-SYS users.
That's where I am running into a problem.
When I execute a SRW.RUN_REPORT call from a PL/SQL block from another DB account, I get following.
Error report -
ORA-04067: not executed, package body "SYS.SRW" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SYS.SRW"