Re: ORA-04091 Question

From: kes <>
Date: Tue, 13 May 2008 15:54:24 -0700 (PDT)
Message-ID: <>

> You'll need to commit (or roll back) the data changes before you try
> selecting from the changed table in a function or a trigger.


Thank you so much. All I needed to do but to change it so that I wrote to a variable, then used the varible; no commit required.  Insert into table Y (column a)
Select column a
From table X
Where column b is null

Loop through table Y
l_var = function (Y.a);
Update table X
Set column b = l_var;

Thank you again for leading me down the correct path.

Alex Received on Tue May 13 2008 - 17:54:24 CDT

Original text of this message