Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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.Received on Thu Jul 24 1997 - 00:00:00 CDT