"SYS.DBMS_PIPE" Must Be Declared

[jason6510]

Hi..
I'm trying to develop a plug-in system for internal messaging using DBMS_Pipes and a session/event component... when I try to pack my message it spits the following error message out ...
PLS-00201 "SYS.DBMS_PIPE" MUST BE DECLARED

Can anyone tell me what I'm doing wrong?

 

[Marco Kalter]

The current oracle user does not have execute privileges on the dbms_pipe package. Connect to the database as SYS, and execute the following:

grant execute on dbms_pipe to public

It can also be that sys.dbms_pipe does not exist, but that is less likely.

------------------
Marco Kalter
Allround Automations

 

[jason6510]

Tried that... still doesn't work .. any other ideas?

 

[Marco Kalter]

Start SQL*Plus, connect as the oracle user of the session of the event, and type:

SQL> exec sys.dbms_pipe.reset_buffer;

If this raises a PLS-00201 error, then either you do not have any privileges, or sys.dbms_pipe does not exist. I can't imagine any other reason.

------------------
Marco Kalter
Allround Automations

 

[jason6510]

Seems to be sorted out ... Thanks