Re: Cancel query in 10g

From: Frank van Bortel <>
Date: Sun, 21 Oct 2007 14:50:29 +0200
Message-ID: <fffhud$ocl$> wrote:
> We are using forms 10g and would like to be able to cancel a query.
> Just setting the module to non-blocking, pops up the Oracle Cancel
> Query pop-up, but when the user clicks on the cancel query button, it
> is breaking connection with the database, but leaving the form open.
> When the user clicks on the X to close the form they get "Your
> connection to the database has terminated. This application will now
> exit". Followed by FRM-40733: PL/SQL built-in DBMS_ERROR_CODE
> failed".
> Is there a way in 10g to cancel a query and leave the form in a usable
> state so that the user can enter a new query and execute it?
> My environment is:
> Forms [32 Bit] Version (Production)
> Oracle9i Enterprise Edition Release - Production
> With the Partitioning option
> JServer Release - Production
> Oracle Toolkit Version (Production)
> PL/SQL Version (Production)
> Oracle Procedure Builder V10. - Production

Think it over - concept wise...

And? Does it still sound like a reasonable question? Thought so.

Frank van Bortel

Top-posting is one way to shut me up...
Received on Sun Oct 21 2007 - 14:50:29 CEST

Original text of this message