Re: dbms_transaction.local_transaction_id in triggers

Shailesh wrote:
> Hello,
>
> I have one requirement, in one single transaction I have to do some
> processing only once. To address this requirement I am planning to use
> dbms_transaction.local_transaction_id.
>
> Means on update <BaseTable> trigger executes and does insertion in some
> other tables, but in some transaction if I update same table multiple
> times (irrelevant of old/new values) NO insertion should happen in
> other tables.
>
> Could you please elaborate on this as it is not clear to me how to
> reset package variable at the end of the transaction.
>
> Please help, i would appreciate if you provide an example.
>
> Thanks & Regards,
>
> Shailesh

Do you want to reset package variables in DBMS_TRANSACTION or in a package you are writing?

If in your package use PRAGMA SERIALLY_REUSABLE.

Demo in Morgan's Library at www.psoug.org under packages.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org