pipes

From: Business Information Services <email_at_bisinfo.com.au>
Date: 1997/05/08
Message-ID: <MPG.ddbf7b5acc1421e989694@nsw-newshost.tpgi.com.au>#1/1

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)
mailto:email_at_bisinfo.com.au
http://www.bisinfo.com.au

Received on Thu May 08 1997 - 00:00:00 CDT