Savepoints in Forms

Is there a way of controlling savepoints and rollbacks in forms? I have a form with many modal windows that show the detail information for a master record. In each of these windows I want to have a CANCEL button so that if a change is made that the user does not want, it can be cancelled and rolled back. If a form is running in SAVEPOINT_MODE it will issue a savepoint on form startup, post and commit. However it seems that the only way to rollback any changes to those savepoints is to use CLEAR_FORM, EXIT_FORM or NEW_FORM. Since the information in the window is for detail records, I don't want to use any of these options.

There is a procedure called ISSUE_ROLLBACK but the docs say it should only be used in an ON_ROLLBACK trigger against a non-Oracle datasource with the savepoint provided by
GET_APPLICATION_PROPERTY(SAVEPOINT_NAME). What I would like to do is issue my own savepoints and rollback to any of those savepoints whenever I want but it seems that Oracle forms will only issue one savepoint per form and that the rollback capability is not accessible outside of an ON_ROLLBACK trigger.

Please respond with e-mail

Thank You

Yusuke Sato
yusuke_sato_at_vela.ca Received on Fri May 02 1997 - 00:00:00 CEST