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/