Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cancel Query on non-blocking form leaves form in unusable state

user7284312Sep 15 2025

Oracle Forms 14.1.2.0.0 (not patched)

Database Version 19.27.0.0

I have a form with the property ‘Interaction Mode’ set to non-blocking.

If I enter query mode and execute a query that takes some time, a ‘Cancel query’ dialog is shown, as expected.

If I then cancel the query, I get the message ‘FRM-40353: Query canceled’, as expected.

But if I then execute the query again, I get a ‘FRM-40301: Query caused no records to be retrieved' almost immediate. But a ’Show errors' shows:

ORA-03123: current operation is still executing in non-blocking mode
Help: https://docs.oracle.com/error-help/db/ora-03123/

If I wait long enough, until the query that was canceled on the database has terminated, I can rerun the query which again shows the ‘Cancel Query’ dialog.

If I exit query mode and close the form, I get the error ‘FRM-40655: SQL error forced rollback’.

Another error that came up is this one:

ORA-25284: Invalid value (null) for ctx->kpucxcwd
Help: https://docs.oracle.com/error-help/db/ora-25284/

Comments
Post Details
Added on Sep 15 2025
14 comments
255 views