Re: Executing stored procedure within trigger

Easy solution...just remove the word 'EXECUTE'.

i.e.,

 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       ADD_COMPONENT( NEW.C_KTP_VIN );    END;
 /

Jeff Barnett wrote:

> 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.
>
> *****

-- 
The views expressed here are mine and do not reflect the official
position of my employer or the organization through which the 
Internet was accessed.