Problem in using dbms_pipe for ORACLE intersession communication
Date: 1997/02/27
Message-ID: <5f31mk$2v5$3_at_news1.sympatico.ca>#1/1
Hi everybody,
I am currently trying to use DBMSPIPE.SQL to build a little
debug tool allowing me to send information from a tested PL/SQL
package running in an ORACLE session 1 to an ORACLE session 2
where the information is read and then written and committed in a
debug table. So I avoid to commit the information written in
other tables in session 1 (I would prefer to write directly in a
debug file from session 1 but up to now I don't know how to do).
Of course I use the documented sequence
pack_message, send_message in session 1
receive_message, unpack_message in session 2.
Up to now I have been able to reread my sent message still being
in session 1 but when I try to read it in session 2 a timeout
occurs without any message reception.
The tested package and the reception script are both run in
sqlplus sessions. My ORACLE version is 7.1.
Is there anything special (undocumented) to be done in session 1
or 2 to be able to read the messages from session 1 in session 2
??
Thank you in advance for your answers.
Jean-Louis Maggetto. Received on Thu Feb 27 1997 - 00:00:00 CET