Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP: dbms_pipe
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