Re: HELP: dbms_pipe

Leonid,

You cannot create a stored object (Packages, Functions, Procedures, etc) using privileges granted to you through a ROLE. Log on as SYS and "GRANT EXECUTE ON DBMS_PIPE TO <your-username>;".

This will solve your problem.

Naresh.

Leonid Lamburt wrote:
>
> I am trying to write a package that uses DBMS_PIPE Package:
> .......
> ......
> CREATE OR REPLACE PACKAGE BODY my_package AS
> PROCEDURE use_pipes IS
> i INTEGER;
> BEGIN
> i := dbms_pipe.create_pipe('tst_pipe');
> END use_pipes;
> END my_package;
> /
>
> It fails to compile with PLS-00201: identifier 'SYS.DBMS_PIPE' must be
> declared
> error.
>
> I have no trouble using DBMS_OUTPUT Package
> Also
> declare
> i integer;
> begin
> i := dbms_pipe.create_pipe('tst_pipe');
> end;
>
> executes fine
>
> What can be wrong? Any help will be appreciated...
Received on Wed Nov 26 1997 - 00:00:00 CST