DBMS_PIPE in Oracle 7.3

From: Keith A. Tucker <tucker_at_radix.net>
Date: 1996/10/06
Message-ID: <3257FC96.2F6E3575_at_radix.net>#1/1


I'm trying to use the DBMS_PIPE package in stored procedures in Oracle 7.3 running on HP-UX 10.01. If I enter the following at the SQL*Plus prompt, I get valid output with no errors:

   EXECUTE DBMS_Output.Put_Line( DBMS_PIPE.Unique_Session_Name );

But, the following line in a stored procedure gives me a PLS-00201 error, indicating that SYS.DBMS_PIPE is not defined:

   pipe_name := DBMS_PIPE.Unique_Session_Name;

As a matter of fact, every line that references one of the DBMS_PIPE functions gives me the "undefined object" error message.

Any ideas as to what could be going wrong?

-- 
#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#

| Keith A. Tucker |
| tucker_at_radix.net |
|=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#
| "Reality is that which, when you stop believing in it - |
| it doesn't go away." |
| Philip K. Dick |
#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#
Received on Sun Oct 06 1996 - 00:00:00 CEST

Original text of this message