Re: Executing stored procedure within trigger

Jeff Barnett wrote:

> 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.
>
> *****
> CREATE OR REPLACE TRIGGER AVI_VEH_MASTER_AFT_INS
> AFTER INSERT ON AVI_VEH_MASTER
> REFERENCING NEW AS NEW OLD AS OLD
> FOR EACH ROW
> BEGIN
>
> EXECUTE ADD_COMPONENT( NEW.C_KTP_VIN );
>
> END;
> /
> *****
> When I run the script I get the following error.
>
> *****
> CREATE OR REPLACE TRIGGER AVI_VEH_MASTER_AFT_INS
> *
> ERROR at line 1:
> ORA-06550: line 6, column 12:
> PLS-00103: Encountered the symbol "ADD_COMPONENT" when expecting one
> of
> the
> following:
> := . ( @ % ;
> Resuming parse at line 6, column 42.
> *****
>
> 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

Remove the word EXECUTE

Matt Arena
Systems Analyst / DBA
Fermi National Accelerator Laboratory
arenam_at_fnal.gov Received on Fri Jul 25 1997 - 00:00:00 CDT