Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can you call a procedure from trigger in Pl/Sql
On 13 Apr 2006 22:51:06 -0700, suneel.nani_at_gmail.com wrote:
>thank for giving reply
>
>
>
>create or replace procedure INSFUN
>AS LANGUAGE JAVA
>NAME 'CustTr.InsFun()';
> /
>CREATE TRIGGER CUST_TR before INSERT ON CUSTOMER
>FOR EACH ROW
>INSFUN;
>end ;
>/
>
>in this example the procedure is created but when i am trying to creat
>trigger it is saying
>ERROR at line 3:
>ORA-04079: invalid trigger specification
>can u please tell me solution thank you
>sunil
Please compare your trigger with Brian's example carefully, and look what is missing after 'for each row'
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Apr 14 2006 - 01:04:48 CDT