Re: pipes

From: Campbell White <>
Date: 1997/05/08
Message-ID: <>#1/1

Business Information Services wrote:
> Hi there,
> I want to set up an error log. I have a table called log and a table
> called transaction. When a transaction comes in I do all this stuff that
> I won't bore you with, but basically it updates various other tables in
> the database.
> If any of it goes wrong I want to rollback the changes to the database
> but I do not want to roll back the entries that have been written to the
> log table.
> Currently what happens is that all changes to the database including the
> LOG table are rolled back.
> I have done some reading and have found a package called DBMS_PIPE which
> the writer says is useful for this situation. Unfortunately he doesn't
> say how.
> Does anyone know how or can help with other suggestions?
> Regards,
> Rowan McCammon.
> --
> Business Information Services
> (For more information call Brad Deveson)
> Tel: (02) 9387-2509 (Australia)
> Fax: (02) 9369-3840 (Australia)

Try downloading "RevealNet PL/SQL Developer Knowlege Base" from

You will find a complete discussion of DBMS_PIPE - with insights, diagrams and examples.

Also check out the "PL/SQL Pipeline" - the only place on the web solely devoted to PL/SQL programming.

Best regards,

Cam White
RevealNet, Inc.
(202) 234-8557 Received on Thu May 08 1997 - 00:00:00 CEST

Original text of this message