Re: ORA-04091 Question
Date: Tue, 13 May 2008 15:54:24 -0700 (PDT)
> 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