Home » SQL & PL/SQL » SQL & PL/SQL » Unable to access DBMS_PIPE from a procedure
Unable to access DBMS_PIPE from a procedure [message #195170] Wed, 27 September 2006 05:10 Go to next message
pulkit_a
Messages: 50
Registered: December 2005
Member
Hi,

I am trying to create the following procedure

create or replace procedure proc_test
as
begin
dbms_pipe.purge('EVE_SCHED_INPUT');
end;
/


It fails giving error

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/4 PLS-00201: identifier 'DBMS_PIPE' must be declared
5/4 PL/SQL: Statement ignored


But when i run dbms_pipe.purge('EVE_SCHED_INPUT');
from sql prompt it run fine.

Please let me know the reason and solution for hte same.

Regards
Pulkit
Re: Unable to access DBMS_PIPE from a procedure [message #195175 is a reply to message #195170] Wed, 27 September 2006 05:28 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You need to grant Execute on DBMS_PIPE explicitly to the user who is compiling the procedure.
Re: Unable to access DBMS_PIPE from a procedure [message #195191 is a reply to message #195175] Wed, 27 September 2006 06:33 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
it might be that you can execute it because of a role granted to you, which is not carried out inside procedures.
Previous Topic: Join Style Performance
Next Topic: Using Bind variable
Goto Forum:
  


Current Time: Sun Dec 04 12:36:22 CST 2016

Total time taken to generate the page: 0.20052 seconds