Re: Cancel query in 10g
Date: Sun, 21 Oct 2007 14:50:29 +0200
Message-ID: <fffhud$ocl$2_at_news1.zwoll1.ov.home.nl>
papalphaus_at_yahoo.com 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 10.1.2.0.2 (Production)
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
> With the Partitioning option
> JServer Release 9.2.0.7.0 - Production
> Oracle Toolkit Version 10.1.2.0.2 (Production)
> PL/SQL Version 10.1.0.4.2 (Production)
> Oracle Procedure Builder V10.1.2.0.2 - Production
>
Think it over - concept wise...
And? Does it still sound like a reasonable question? Thought so.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Sun Oct 21 2007 - 14:50:29 CEST