Re: Dynamic Generate sequences ~~

From: <handyn_at_my-deja.com>
Date: Mon, 28 Aug 2000 06:59:11 GMT
Message-ID: <8od2jp$api$1@nnrp1.deja.com>

Actually I'm not quite sure what you mean.

by the way from beginning, you just create your sequence e.g : MySeq then create the trigger.

Create or replace trigger TAB_Ins
before insert on YOUR_TABLE for each row declare
x number;
Begin

   select MySeq.nextval
   into x
   from dual;
   :new.Field := x;
end;

I hope it could solve your problem

Handy

In article <8ocn5e$us6$1_at_nnrp1.deja.com>, Chun-Yen <agi_at_haa.com.tw> wrote:
> Hello,theres
>
> Could I use trigger to dynamic generate sequences??
> My goal is whenever a new record insert, a sequence generated.
> for example, table test( c1 number, c2 varchar2(100)),
> Now, c1 is automatic assigned by trigger and a sequence. 1 2 3...
> How to generate seq_test1 for 1st record,seq_test2 for 2nd record...
> once a new record insert a new sequence must generate.
>
> "It seems *impossible* since COMMIT is not allowed in trigger."
> Any ideas ??
>
> Agi
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 01:59:11 CDT