dbms_pipe error

From: Vidar Mikkelsen <vmikkels_at_online.no>
Date: 1997/08/02
Message-ID: <01bc9f90$9dbc4680$18014382_at_default>#1/1


[Quoted] What is wrong with this sample procedure ??

I use this release :
Personal Oracle7 Release 7.2.2.3.1 - 90 day trial license PL/SQL Release 2.2.2.3.1 - Production
(Win95)

create or replace procedure test is

stat integer ;
xx varchar2(100);

begin

        dbms_output.enable(10000);         

        xx := 'test string';         

	dbms_pipe.pack_message(xx);
	stat := dbms_pipe.send_message('testpipe');
	
	dbms_output.put_line(stat);
	

end;
/
show errors;



LINE/COL ERROR
-------- -----------------------------------------------------------------
7/2      PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
7/2      PL/SQL: Statement ignored
8/2      PL/SQL: Statement ignored
8/10     PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
----------------------------------------------------------------------------


Vidar. Received on Sat Aug 02 1997 - 00:00:00 CEST

Original text of this message