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
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
Received on Fri Apr 14 2006 - 00:51:06 CDT