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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Apr 2006 08:04:48 +0200
Message-ID: <lqeu32dqerih3tvdthrt8jrvfrsqjprads@4ax.com>


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 DBA
Received on Fri Apr 14 2006 - 01:04:48 CDT

Original text of this message

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