Home » Developer & Programmer » Forms » PL/SQL equivalent of ROLLBACK in Oracle Forms (Oracle 9i Forms)
PL/SQL equivalent of ROLLBACK in Oracle Forms [message #337711] Thu, 31 July 2008 17:01 Go to next message
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.
Re: PL/SQL equivalent of ROLLBACK in Oracle Forms [message #337736 is a reply to message #337711] Fri, 01 August 2008 00:05 Go to previous messageGo to next message
Littlefoot
Messages: 21821
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).
Re: PL/SQL equivalent of ROLLBACK in Oracle Forms [message #337980 is a reply to message #337711] Sat, 02 August 2008 00:00 Go to previous message
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);
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:
  


Current Time: Sat Nov 09 17:48:41 CST 2024