OraFAQ Forum: Forms » PL/SQL equivalent of ROLLBACK in Oracle Forms

Home » Developer & Programmer » Forms » PL/SQL equivalent of ROLLBACK in Oracle Forms (Oracle 9i Forms)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL equivalent of ROLLBACK in Oracle Forms [message #337711]

Thu, 31 July 2008 17:01

urnikhil
Messages: 42
Registered: March 2008

Member

Hi All,

My form relies on SQL statements based data manipulation. To commit these transactions I am using STANDARD.COMMIT

Could anyone let me know if there is something equivalent to ROLLBACK in Oracle Forms? I know that normal ROLLBACK in Forms is equivalent to CLEAR_FORM.

Any help would be greatly appreciated.

- Nik.

Report message to a moderator

Re: PL/SQL equivalent of ROLLBACK in Oracle Forms [message #337736 is a reply to message #337711]

Fri, 01 August 2008 00:05

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Huh, I don't know; but, until you get a better answer, you might try with EXIT_FORM(NO_VALIDATE); it will exit the form without committing (and won't ask you "Do you want to save the changes?") (but you'd lose information you've entered into the form's items).

Report message to a moderator

Re: PL/SQL equivalent of ROLLBACK in Oracle Forms [message #337980 is a reply to message #337711]

Sat, 02 August 2008 00:00

shahnirav86
Messages: 13
Registered: June 2008
Location: anand,gujarat

Junior Member

hi,
first you have to write post changes to apply
If you want to to do something like transction
if transaction success then
Exit_form(no_commit,no_rollback);
When one of process fail then
Exit_form(no_commit,rollback);

Report message to a moderator

Previous Topic:	a form extract data from a table & save in another one (only at insert)
Next Topic:	Oracle qo g application with web

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 15 21:36:31 CDT 2025