Rollback in Forms [message #81448] |
Wed, 19 February 2003 01:22 |
Adam Macha
Messages: 3 Registered: February 2003
|
Junior Member |
|
|
Hi
I have a situation.
I use Developer6 and I happen to have one form which has several procedures in it. The data accessed is large enough. Now there is one last procedure which fires this error. If I disable it the form finishes ok.
I suspect rollback segments gets full because if i run the form without that procedure and run that procedure outside the form it works.
Is there a way i can tell form no to use rollback ( NO_ROLLBACK)
Or is there something I am not aware of ?
|
|
|
Re: Rollback in Forms [message #81452 is a reply to message #81448] |
Wed, 19 February 2003 03:23 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
when you select/insert/update many records, your memory for a rollback segment gets overloaded
You should extend the rolbacksegment capacities (Mbytes). Notice that the command rolback; has nothing to do with the term rolback segment.
|
|
|
Re: Rollback in Forms [message #81461 is a reply to message #81452] |
Thu, 20 February 2003 08:29 |
Adam Macha
Messages: 3 Registered: February 2003
|
Junior Member |
|
|
Is there a way i can tell the form not to Use Rollback segments. What I know is, Rollback will Undo when the process is not successful. But I dont mind if it does not undo
Any idea
Thanks
Adam
|
|
|