| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL update query - help please!
An update is not totally complete even in the After Update trigger until a
commit occurs. Oracle will not allow an Insert/Update/Delete trigger to query
the table the query is based on. This can only be done in a statement level
trigger.
What I have done is create a package into which the trigger passes the key info
for the record and the package saves this. The package will then have a
function that loops through the list of keys and calls your
P_CHK_PCODE_GRP(:new.act_id,:new.empid) function. This package function is
called by the Statement level trigger.
This is a big pain, but it is a documented big pain in some of the Oracle documentation. Received on Fri Jan 23 1998 - 00:00:00 CST
 |
 |