Basics - Oracle Dbms Pipe Commands

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 44 of 49

Oracle Dbms Pipe Commands

give the dbms_pipe commands in oracle of there execution,which are used to send & recieve messages what is the max size can sent at one go

Total Answers and Comments: 3

Last Update: December 02, 2009 Asked by: rudhra97

Sponsored Links

Best Rated Answer

—

Submitted by: saginandkishore

dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes.

The important functions/procedures in this package are

(1) CREATE_PIPE to create a new pipe
==> dbms_pipe.create_pipe(pipename) where pipename can be Oracle supplied or user defined as below

dbms_pipe.create_pipe(dbms_pipe.unique_session_name) -- Creates a PIPE based on your unique Session ID

or

pipename constant varchar2(100) := 'TEST_PIPE';
dbms_pipe.create_pipe(pipename);

(2) Having created the pipes try sending some data through the pipe. To send data prepare the data using dbms_pipe.pack_message(mesg_buf) where mesg_buf can be varchar2, char, number. Basically this procedure is overloaded for Numbers, Varchar2 and date. For long and raw data use the corresponding DBMS_PIPE.PACK_MESSAGE_RAW method. This procedure basically places the data into buffer which can be send on any pipe using the dbms_pipe.send_message(pipename) function.

(3) At the other end of the pipe you can receive the data using dbms_pipe.receive_message function. This functions fetches the data into buffer from where you can unpack the data using dbms_pipe.unpack_message function. This function gets the data in the buffer into a message buffer.

These are the basic commands that you can use for working with pipes. For more details visit oracle documentation.

Above answer was rated as good by the following members:
harit79, bhatnagar_neeraj, ashish.nag, emraan

June 18, 2008 03:47:15

lotus123

Member Since: June 2008 Contribution: 1

RE: Oracle Dbms Pipe Commands

dbms_pipe
plrease give accurate answer.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

June 24, 2008 19:48:19

saginandkishore

Member Since: June 2008 Contribution: 5

RE: Oracle Dbms Pipe Commands

dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes.

The important functions/procedures in this package are

(1) CREATE_PIPE to create a new pipe
> dbms_pipe.create_pipe(pipename) where pipename can be Oracle supplied or user defined as below

dbms_pipe.create_pipe(dbms_pipe.unique_session_name) -- Creates a PIPE based on your unique Session ID

or

pipename constant varchar2(100) : 'TEST_PIPE';
dbms_pipe.create_pipe(pipename);

(2) Having created the pipes try sending some data through the pipe. To send data prepare the data using dbms_pipe.pack_message(mesg_buf) where mesg_buf can be varchar2 char number. Basically this procedure is overloaded for Numbers Varchar2 and date. For long and raw data use the corresponding DBMS_PIPE.PACK_MESSAGE_RAW method. This procedure basically places the data into buffer which can be send on any pipe using the dbms_pipe.send_message(pipename) function.

(3) At the other end of the pipe you can receive the data using dbms_pipe.receive_message function. This functions fetches the data into buffer from where you can unpack the data using dbms_pipe.unpack_message function. This function gets the data in the buffer into a message buffer.

These are the basic commands that you can use for working with pipes. For more details visit oracle documentation.

Is this answer useful? Yes | No

3 0

Overall Rating: +3

December 01, 2009 18:06:50

imranbaig.geek

Member Since: August 2009 Contribution: 3

RE: Oracle Dbms Pipe Commands

------Funtions------

DBMS_PIPE.CREATE_PIPE:- for creating a pipe

DBMS_PIPE.SEND_MESSAGE:- For sending message

DBMS_PIPE.REMOVE_PIPE:- for removing message

DBMS_PIPE.RECEIVE_MESSAGE:- For receiving message

------Procedures------

DBMS_PIPE.PACK_MESSAGE:- for packing varchar varchar2 char messages

DBMS_PIPE.PACK_MESSAGE_RAW:- for Long and Raw messages

DBMS_PIPE.UNPACK_MESSAGE:- FOr Unpacking

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank