GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 44 of 49    Print  
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 | NoAnswer is useful 0   Answer is not useful 1Overall 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 | NoAnswer is useful 3   Answer is not useful 0Overall 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 | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape