Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: Mutant tables in read-only Triggers

Re: Mutant tables in read-only Triggers

From: DStevens <dstevens_at_navidec.com>
Date: Wed, 21 Nov 2001 08:56:03 -0700
Message-ID: <3BFBCE93.B293CAE0@navidec.com>

Try pulling the select statement into a function that uses autonomous transaction.

That should solve the problem.

>
Received on Wed Nov 21 2001 - 09:56:03 CST

This message: [ Message body ]
Next message: Michael L. Hostbaek: "sql query build question"
Previous message: Alistair: "Re: Lawson Software and Oracle"
In reply to: Marcos Barroso: "Mutant tables in read-only Triggers"
Next in thread: Thomas Kyte: "Re: Mutant tables in read-only Triggers"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US