Home » SQL & PL/SQL » SQL & PL/SQL » After executing Dbms_pipe package session get blocked
After executing Dbms_pipe package session get blocked [message #187355] Sat, 12 August 2006 10:46 Go to next message
vamsi_krishna_777
Messages: 7
Registered: August 2006
Location: Mumbai
Junior Member

Hi

In one session I am i have executed following blocks
VARIABLE x NUMBER;
BEGIN SYS.DBMS_PIPE.PACK_MESSAGE('SQL'); END;
BEGIN :x:= SYS.DBMS_PIPE.SEND_MESSAGE ('VAMSI1'); END;

In another i executed following blocks
VARIABLE Z NUMBER;
BEGIN SYS.DBMS_PIPE.UNPACK_MESSAGE(:Z); END;

Then my session got Bolck
Can u suggest me why this happened
What should i do to provent it

Regards
vamsi krishna
Re: After executing Dbms_pipe package session get blocked [message #187366 is a reply to message #187355] Sat, 12 August 2006 17:18 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
You need to receive the message first, using DBMS_PIPE.RECEIVE_MESSAGE.
Previous Topic: Frequent COMMIT is Culprit or anything else?
Next Topic: Existing state of package... (Merged)
Goto Forum:
  


Current Time: Sat Dec 10 20:50:19 CST 2016

Total time taken to generate the page: 0.08065 seconds