Re: Dynamic Generate sequences ~~

From: <no.email_at_no.spam>
Date: Mon, 28 Aug 2000 14:26:17 GMT
Message-ID: <20000828.14261744@slu40736.hae.hydro.com>

I don't know why you want to dynamically generate sequences,but if you

are using Oracle 8.1.6 (maybe earlier releases as well), you can try to

use autonomous transactions.
In your trigger, call a stored procedure which uses an autonomous transaction. In that procedure, use dbms sql to create the sequence.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-08-28, 5:43:46, schreef Chun-Yen <agi_at_haa.com.tw> over het thema

Dynamic Generate sequences ~~:

> 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.
Received on Mon Aug 28 2000 - 09:26:17 CDT