Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PRAGMA AUTONOMOUS_TRANSACTION in a trigger
Ken Denny wrote:
> whitegoose_at_inorbit.com wrote:
>
>>That is to say, I need my trigger, on the JOB table, to check to see
>>the JOB.JOBTYPE = 'RES' before insert/update. If so I then check to
>>whether another row in JOB with a JOBTYPE = 'RES' has the same
>>(STREETNAME, STREETNO, STREETTYPE, CITY). If so, I >>RAISE_APPLICATION_ERROR.
>>So I need to be able to select from JOB to compare the values of the >>current row to the values of the other rows. >> >>FYI. I am trying to write code that will work for 8i but the client >>will soon be upgrading to a version that is unknown at this stage. I >>would not expect it to be 10g
They were.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Mon Apr 04 2005 - 14:17:22 CDT