OraFAQ Forum: Forms » Question about using "ROLLBACK" in form procedure

Home » Developer & Programmer » Forms » Question about using "ROLLBACK" in form procedure

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

Question about using "ROLLBACK" in form procedure [message #81196]

Tue, 21 January 2003 19:18

Penn
Messages: 1
Registered: January 2003

Junior Member

Dear All,
I have a question about using "ROLLBACK" in form procedure. When using "ROLLBACK" in form procedure, it will have a fatal side effect since "ROLLBACK" = "CLEAR_FORM". "CLEAR_FORM" will thus flush some important setting and finial make my form out of order.
Is there any compansation method to using "ROLLBACK" but not "CLEAR_FORM". Well, I have test all parameters of "CLEAR_FORM" such as do_commit, to_savepoint sth. but they get flush in the same way. Thanks!

Regards,
Penn

Report message to a moderator

Re: Question about using "ROLLBACK" in form procedure [message #81259 is a reply to message #81196]

Mon, 27 January 2003 05:41

magnetic
Messages: 324
Registered: January 2003

Senior Member

create a databaseprocedure like
my_proc is
begin
rollback;
end;
now you gotto call this databaseprocedure in your form where you want to rollback.
that means no clearform anymore since this rollback happens at database level

Report message to a moderator

Previous Topic:	how can we call oracle report in form 5.0
Next Topic:	Developer 2000 Tutorial

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 13:07:24 CDT 2024