Setting Autocommit OFF inside Oracle Forms

[kSozuner]

I'm inserting rows in a loop (in a WHEN-MOUSE-CLICK event), and want to ROLLBACK when an error occurs.But than I realized that the inserts take place immediately.
Does anyone know howto set Autocommit Off inside Oracle Forms? Forms does not recognize the command :
SET AUTOCOMMIT OFF
Is there a way to do that?

 

[sem]

Are you running against non-Oracle database?

Regards, Dima

 

[kSozuner]

The DB is Oracle8 and I'm using Forms 5.

 

[sem]

I'm sure you're performing commit in code as the default (and probably single) mode in forms is AUTOCOMMIT OFF. Moreover, by default Forms makes all updates in base table during commiting form, thus eliminating interaction with server.

Regards, Dima