Oracle Reports (MOSC)

MOSC Banner

SRW Report Writer Package 12c

edited Oct 11, 2020 4:51AM in Oracle Reports (MOSC) 4 commentsAnswered

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"

Tagged:

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