dbms_pipe error
From: Vidar Mikkelsen <vmikkels_at_online.no>
Date: 1997/08/02
Message-ID: <01bc9f90$9dbc4680$18014382_at_default>#1/1
LINE/COL ERROR
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