Re: PL/SQL 8.0.5 - A way to find if a transaction is allready running?

All transactions immediately start after the previous commit or rollback.

Hth,

Sybrand Bakker, Oracle DBA

"Rui Rosa Mendes" <rrm_at_midialog.pt> wrote in message news:A53_5.289$bl4.3939_at_nreader1.kpnqwest.net...
> Can I find if a transaction is allready initiated?
>
> Ex:
> In a hight level language I begin a transaction ...
>
> PSEUDO-CODE
> BeginTransaction(sqlHandler);
>
> ExecuteQuery('Update .....', sqlHandler);
> ExecProc('package.InsertHeader(iId)', sqlHandler);
>
> Commit(sqlHandler);
>
> PL/SQL
> Create or Replace Package
>
> InsertHeader(iId integer)
> begin
> -- Transaction not allready running ?
> if not TRANSACTION RUNNING (How can I do this?) then
> set transaction read write;
> end if;
>
> Insert into table
> (...)
> values
> (...)
>
> if not TRANSACTION RUNNING (??) then
> commit
> end if;
>
> end;
>
>
>
>
Received on Fri Dec 15 2000 - 13:49:33 CST