Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Executing stored procedure within trigger
I've create & compiled a stored procedure in 7.1.5 successfully as well as granted access to public. I'm now wanting to call that procedure from within a trigger. Below is the script for creating the trigger.
I've also prefixed the owner to the beginning of the procedure and still no luck. If I enter the execute line of the trigger in at the SQLPLUS prompt it works with without any problems. Any ideas why the create trigger is failing?
TIA
Jeff
Received on Tue Jul 22 1997 - 00:00:00 CDT