Solved

Oracle forms - Gives me a cancel query dialog on long querys

Posted on 2003-11-12
2
1,368 Views
Last Modified: 2008-02-07
when launching my form on long queries I get a oracle generated (I think as I didnt build it) message saying

cancel query
Press cancel to end this database operation.

I havework with forms for a year now and have never encountered this before. Does anyone know how I can shut this off and why I am getting this message, as I have other applications with longer quieries where this message does not show up.
0
Comment
Question by:Maritimer
2 Comments
 
LVL 15

Accepted Solution

by:
andrewst earned 20 total points
ID: 9732365
Look at the form-level parameter "Interaction Mode", it has been set to "Non-blocking", whereas the default is "Blocking".
0
 

Author Comment

by:Maritimer
ID: 9732431
Thanks

I must have accidentally changed that.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question