Excuse me, great god, by whom see how Oracle stored procedure calls, and execute the stored procedure? How to see this table is a trigger, and how to find out which trigger calls the stored procedure?

CodePudding user response:

Should not the function

CodePudding user response:

Select * from user_triggers; - check the trigger information
Select * from user_dependencies; - view object depend on the situation

CodePudding user response:

Open the audit, you can through the audit by whom view the stored procedure calls

CodePudding user response:

A more stupid method is to export the database SQL, global search confirmation call

CodePudding user response:

See who call a stored procedure is Oracle? And execute a stored procedure? How to see this table is a trigger, and how to find out which trigger calls the stored procedure?

CodePudding user response:

[Ctrl + Enter sent]
See who call a stored procedure is Oracle?
I usually check the stored procedure which tables are involved, then look at the session, find the pid and # serial, and then determine whether the execution,
And execute a stored procedure?
The best own writing stored procedures with log statements track and exception handling,
The trigger haven't been used,