SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how catch variable value from trigger

MattSkJan 3 2008 — edited Jan 3 2008

situation:
I have trigger which is fired after update on any value in table aaa, trigger is used to archive all values in updated row from table aaa to table aaa_archive, in trigger is calculated sys_guid() ID for archive record ID, I need to get this ID, and forward to php code, because of some filesystem archive operations with files(files are archvived as well, and I need create connection between this file and archived record in DB).
It is needed to use trigger instead of some own pl/sql archive procedure.

Can somebody help?

Thx :)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2008

Added on Jan 3 2008

11 comments

583 views