Re: How to generate a unique and sequential string/number for TranxID for Triggers

mullin wrote:
>
> Hi,
>
> Now, I'm using dbms_transaction.local_transaction_id to
> generate a unique ID among different tables' triggers (insert, update,
> delete) since they
> are under same transaction.
>
> But, the transaction id isn't in sequence that i want to sort by
> transaction id to know
> the sequence.
>
> Any suggestions and solutions?
>
> Thanks!

If the first table in the transaction is always known, then use a sequence and use seq.nextval, and seq.currval for all subsequent tables.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------