Re: Student: Simple PL/SQL Question

Hi Kenny,

the difference between invoking a procedure standalone and within a trigger is that within a trigger for each row you cannot refer to a row of the table that just fired the trigger. Neither can you use (= select, insert, update, delete) any of the rows dependent of that table or depending on that table. You will see an inconsistent state of all those tables within your trigger while you will always see a consistent state from within a standalone proc.

The only rows you are allowed to access within a "for each row" trigger are the :new and :old records. This is the reason why your procedure fails (it just won't see any other rows from your table so your "select ... into ..." does not return any data.)

Please do not crosspost any more.

Martin Received on Sat Apr 28 2001 - 15:54:14 CDT