Re: Executing stored procedure within trigger

On Tue, 22 Jul 1997 17:53:55 -0400, Jeff Barnett <JBARNET2_at_FORD.COM> wrote:
>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?

Yes, because you don't call stored procedures and functions inside a trigger using the EXECUTE statement.

Jonathan Ingram Received on Wed Jul 23 1997 - 00:00:00 CDT