Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: can you call a procedure from trigger in Pl/Sql

Re: can you call a procedure from trigger in Pl/Sql

From: <suneel.nani_at_gmail.com>
Date: 13 Apr 2006 22:51:06 -0700
Message-ID: <1144993866.766107.248600@t31g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US