With the new Forms 14c release, I have the following issue:
- A form with a block with +/- 250 database items
- Query data source is a view
- Form is in non-blocking mode
- Max query time is default, 0
If I enter query/execute query, with or without criteria, I get this ‘FRM-40353 Query canceled’ error. If I trace the session with DBMS_MONITOR on, I see the cancel event wait state:
WAIT #139962294978632: nam='SQL*Net break/reset to client' ela= 54 driver id=1952673792 break?=0 p3=0 obj#=165510 tim=2339768909295
Now, if I
- reduce the number of database items, set half of them ‘database item’ to ‘No’, it works again.
- remove the ORDER BY on the block, it works again
A fresh simple form, without any triggers (PRE-FORM, PRE-QUERY, POST-QUERY, etc) with one block, based on the same view, all columns, has the same issues.
The same form on Forms 12c release has no issues.
What makes the non-blocking fetching loop decide to cancel the query?
There is a difference in behavior, OCI 19.24.0.0.0 (used by Forms 12c) and OCI 23 23.8.0.25.4 (Forms 14c).
We are running on Oracle Database 19.28