How to use Save Point in Oracle Forms Developer 6i?

95 pts.
Tags:
Oracle Developer
Oracle Forms
Save Point
How do I work save point and rollback in Oracle Forms Developer 6i with using post?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    The question is not very clear.

    Could you please explain your requirement a little futher?  Maybe give an example of what you want to do?

    Did you try something and failed?
    85,015 pointsBadges:
    report
  • Omrsft
    I use the Post Procedure in my Forms developer 6i
    I do insert , update and delete on the data  that executes during the current Runform session , then POST procedure .
    I want   do UNPOST .
    I was use raise form_trigger_failure , But is not avail .
    Is it use savepoint before POST than Rollback  OK  and HOW  ?

     
    95 pointsBadges:
    report
  • Omrsft
    see I mean this command .


    POST Built-in Description Writes data in the form to the database, but does not perform a database commit. Oracle Forms first validates the form. If there are changes to post to the database, for each block in the form Oracle Forms writes deletes, inserts, and updates to the database. Any data that you post to the database is committed to the database by the next COMMIT_FORM that executes during the current Runform session. Alternatively, this data can be rolled back by the next CLEAR_FORM.



    But i don't want to clear_from because i did not commit_form .
    What  i need exactly as the following
    I do so many post statement in middle of the work i want to go back to specific statement and ROLLBACK please help .
    HOW CAN I DO THIS ?
    95 pointsBadges:
    report
  • carlosdl
    I don't have the documentation at hand, but look for the  issue_savepoint and issue_rollback built-in procedures.

    They could be what you are looking for.
    85,015 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: