Oracle Triggers variable

From: Kovu <kovutech_at_gmail.com>
Date: 8 May 2007 00:53:10 -0700
Message-ID: <1178610789.996313.326370@u30g2000hsc.googlegroups.com>

Hello, I'm writing this post to ask you about If can I get a variable of trigger to my code in asp.net 2.0?.

I have this code in my trigger:

create or replace TRIGGER CORRELATIVO_EXPEDIENTE BEFORE INSERT ON EXP REFERENCING NEW AS New FOR EACH ROW DECLARE contador NUMBER; BEGIN contador:=0; SELECT NVL(MAX(id_exp),0) +1 INTO contador FROM EXP; :NEW.id_exp:=contador; END;

I want to get "contador".

Thanks for all. Received on Tue May 08 2007 - 02:53:10 CDT