question

bkatwal avatar image
bkatwal asked

To find the Name of the procedure inside trigger which updated the table

Hi, I am working on oracle, I have a situation where i need the name of the procedure which is updating the table and that name i want to use inside trigger for some specific task. Example: Lets say I have a table "my_table" which is getting updated by either "my_procedure1" or "my_procedure2" procedure. Now, inside trigger *i want to check which procedure has updated the table* and do the task according to that. Thanks in Advance
oracleprogramming
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
dvroman avatar image
dvroman answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.