OraFAQ Forum: Forms » problem in rollback

Home » Developer & Programmer » Forms » problem in rollback

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

problem in rollback [message #187720]

Tue, 15 August 2006 02:54

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii All

i created a form that have a menu that contain a rollback button
when press on it , it should performs the action of rollback

but in this form when press on it, it clears the form from all the data on it

Thanks for everyone helped and helping me

Report message to a moderator

Re: problem in rollback [message #187731 is a reply to message #187720]

Tue, 15 August 2006 04:03

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

Senior Member
Account Moderator

If I'm not wrong, this is expected behaviour of Oracle Forms when ROLLBACK is executed.

Report message to a moderator

Re: problem in rollback [message #187733 is a reply to message #187720]

Tue, 15 August 2006 04:42

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Do you mean that the action of rollback is clearing the block!!!!!!!!!!!!!!!!!

Report message to a moderator

Re: problem in rollback [message #187781 is a reply to message #187733]

Tue, 15 August 2006 10:24

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

Senior Member
Account Moderator

Actually, I believe that Oracle doesn't care too much what I think about it. This is what Oracle documentation says about the issue:

Oracle

If you use a PL/SQL ROLLBACK statement (...), Form Builder interprets that statement as a CLEAR_FORM built-in subprogram with no parameters.

Report message to a moderator

Re: problem in rollback [message #187862 is a reply to message #187720]

Wed, 16 August 2006 01:15

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

then how can i solve this problem

by the way i made a code for Rollback

CLEAR_BLOCK(NO_VALIDATE);
CLEAR_RECORD;
ROLLBACK;

it works fine for all forms except this form
in this form it clear the block
i don't why

Report message to a moderator

Re: problem in rollback [message #187877 is a reply to message #187720]

Wed, 16 August 2006 03:11

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

I use ISSUE_ROLLBACK(NULL);

Report message to a moderator

Re: problem in rollback [message #188134 is a reply to message #187862]

Thu, 17 August 2006 04:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I assume you will have to go to your main block and do an execute-query.

David

Report message to a moderator

Re: problem in rollback [message #650826 is a reply to message #187877]

Wed, 04 May 2016 12:40

bahubcd
Messages: 40
Registered: July 2007
Location: Bangalore

Member

@wency, ISSUE_ROLLBACK(NULL); works to rollback.

Thanks.
Bahubcd

Report message to a moderator

Re: problem in rollback [message #650833 is a reply to message #650826]

Wed, 04 May 2016 19:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I doubt that Wency has been waiting a DECADE for your words of wisdom.

Report message to a moderator

Previous Topic:	progress bar(necessary)
Next Topic:	11g Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 20 04:26:54 CDT 2026