On 8 mayo, 09:55, sybrandb <sybra..._at_gmail.com> wrote:
> On May 8, 10:41 am, Kovu <kovut..._at_gmail.com> wrote:
>
>
>
>
>
> > On 8 mayo, 09:26, sybrandb <sybra..._at_gmail.com> wrote:
>
> > > On May 8, 9:53 am, Kovu <kovut..._at_gmail.com> wrote:
>
> > > > 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.
>
> > > You would set up a package with a variable.
> > > In the package is 1 procedure to set the variable (which is to be
> > > called by the trigger)
> > > and one function to retrieve the variable.
> > > You do realize your current approach (select max(id) from <table on
> > > which is the trigger>) won't work, and what's more is unscalable? The
> > > full table scan on exp is going to take more an more time. Why don't
> > > you use a sequence?
>
> > > --
> > > Sybrand Bakker
> > > Senior Oracle DBA
>
> > Can I use a sequence on version 9i?
>
> > Thanks.- Hide quoted text -
>
> > - Show quoted text -
>
> sequences have been available since Oracle 6
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -
Ok thanks for all, Im a new user of Oracle :s, Im lost a bit xD
Received on Tue May 08 2007 - 03:57:10 CDT
