This discussion is archived
2 Replies Latest reply: Nov 30, 2012 3:50 AM by vansul RSS

Cancel Database Operation

973608 Newbie
Currently Being Moderated
How can i Cancel the Database Query if taking so much time at run time.
  • 1. Re: Cancel Database Operation
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    Generally speaking, you cannot. However, if your blocks are based on tables, meaning you are not performing your own SELECT * FROM EMP, then if you set the form's "Interactive Mode" to Non-Blocking, a Cancel option will be displayed after the query has run for a brief period. Refer to the Builder online help for more information.
  • 2. Re: Cancel Database Operation
    vansul Pro
    Currently Being Moderated
    It is not possible to cancel your PL/SQL or procedures or triggers of your forms or db
    but if your block is based on database property yes and you are querying on the block like using EXECUTE_TRIGGER then your can use
    set the form's "Interactive Mode" to Non-Blocking
    By doing this your forms can give you the control to use to cancel the database query.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points