DBMS_PIPE in Oracle 7.3
From: SUMITS <SUMITS_at_prodigy.net>
Date: 1996/11/25
Message-ID: <3299FD01.F5F_at_prodigy.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:
Date: 1996/11/25
Message-ID: <3299FD01.F5F_at_prodigy.net>#1/1
Hi Keith,
I'm having a similar problem as you described below.
I get the exact same message on lines which have DBMS_PIPE
in it. Oracle 7.3 is running on an NT machine. Could
you share your solution/insight on this problem.
Thanks,
Sumit
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?
-- #=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#Received on Mon Nov 25 1996 - 00:00:00 CET
| 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 |
#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#=#