Re: How to find that after "post" there was no "commit"

> Hi,
>
> I am working with Forms Developer v4.5 and v6.
> Maybe someone know how to find that after "post" there was no "commit"
>
> For ex. pl/sql code :
>
> POST;
> ....
> ....
> ....
> ....
> IF ("there_was_no_commit ???") THEN
> COMMIT_FORM;
> END IF;
>

Try

select decode (count(*), 0, 'no changes', 'changes') from v$transaction;

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Solutions GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------