DBMS_PIPE:

The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to the other.) You can use the procedures pack_message & send_message to pack a message into the pipe, then it send to the other session in the similar instance.

At the other part of the pipe, you can use the procedures receive_message and unpack_message to receive and unpack the message. The Named pipes are helpful in many ways. For illustration, you can write the routines in C which allow an external servers to collect the information, then send it through pipes to the procedures stored in an Oracle database.

 

Posted Date: 10/6/2012 7:47:53 AM | Location : United States

Ask an Expert

Related Discussions:- Package dbms pipe in pl/sql, Assignment Help, Ask Question on Package dbms pipe in pl/sql, Get Answer, Expert's Help, Package dbms pipe in pl/sql Discussions

Write discussion on Package dbms pipe in pl/sql
Your posts are moderated

Write your message here..

Related Questions

Package - pl/sql programming, What Is a Package? The package is a sch... What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Second step at defining type sid in sql, Second Step at defining type SID i... Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

Pits, PITS Depressions in secondary cell wall is called pit. A pi... PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

Defining and declaring collections, Defining and Declaring Collections T... Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Package standard in pl/sql, Package STANDARD package named STANDARD d... Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

Package utl file in pl/sql, UTL_FILE: The Package UTL_FILE permits you... UTL_FILE: The Package UTL_FILE permits your PL/SQL programs to read & write operating system (OS) text files. It gives a restricted version of the standard OS stream file I/O,

Packaging cursors, Packaging Cursors   You can split a cursor specific... Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec

Example of table literal - sql, Example of Table Literal - SQL Exampl... Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'

Parameter and keyword description - records, Parameter and Keyword Descript... Parameter and Keyword Description: record_type_name: This identifies the user-defined type specifier that is used in the subsequent declarations of the records. NOT N

Exceptions - syntax, Exceptions An exception is the runtime error or wa... Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system