| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> New DBMS_PIPE Utilities
A new set of free utility programs have been added to the "Archives" section
of the PL/SQL Pipeline - a free internet comunity for Oracle PL/SQL
Development hosted by Steven Feuerstein and sponsored by RevealNet.
Join the Pipelines at http://www.revealnet.com/pipeline.htm for lively discussion groups, technical tips and free white papers & utilities. The pipelines are absolutely free, with almost 7,000 members. Enjoy!
The dbpipe.zip file contains two files: dbpipe.sql and dbpipe2.sql. The dbpipe.spp file contains a package of interesting utilities illustrating use of DBMS_PIPE programs. These utilities include a forwarding program to pass pipe messages from one pipe to another, a peek program to inspect and replace pipe messages, and generic unpack and pack programs.
The dbpipe2.sql file illustrates the use of DBMS_PIPE to implement communications between a PL/SQL background server program and client programs. Clients communicate requests over a database pipe on which the server listens and receive responses on pipes unique to each session. The server can be set to place debugging infofmation into a table.
Both files are exerpted from "Oracle Built-in Packages" (O'Reilly and Associates, written by Steven Feuerstein, Charles Dye and John Beresniewicz). These packages was created by John Beresniewicz to demonstrate how to utilize database pipes and also make it easier to take advantage of DBMS_PIPE functionality.
Our thanks to John B of Savant Corporation for sharing this code. And when you get a chance, check out Oracle Built-in Packages in your nearest technical bookstore. You will find it immensely useful!
Best wishes,
Cam White
RevealNet, Inc.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 28 1998 - 13:15:19 CDT
 |
 |