var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trigger when exit
I need to call a stored procedure automatically when the user exits out of the oracle session. Is there a trigger that I can use to do that.
CREATE TRIGGER logoff_t ON LOGOFF
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Thanks for your reply.
I also need to specify in the trigger that if a specific procedure is called then only trigger the logoff trigger. For example
I have 2 procedures
2) SP_END (this procedure will be called inside the trigger)
I need to say that trigger the logoff trigger when the user logs off the oracle session ONLY IF the user has called the SP_BEGIN procedure.
Probably need to set a package spec variable during SP_BEGIN, and then test the value of that variable in the body of the LOGOFF trigger. If it's an acceptable value, fire off the code in the trigger. Otherwise, exit it immediately.