Hi,
I found any other issue on using Oracle SQL in BaseX by SqlExecutePrepared. It caused by stmt.getParameterMetaData().getParameterCount(). The current workaround ignores the thrown Exception and will continue the statement execution.
But produce may open cursors on in the Database. So finally it will run into ora-1000 "Maximum open cursors exceeded."
By totally avoiding the call of getParameterCount this issue will avoid. So I will provide an other fix.
What do you prefer:
a) check for "Oracle" in stmt.getConnection().getMetaData().getDatabaseProductName() and skip the parameter test at all
or
b) add an other option "checkParameters" (default true) like "timeout" and skip getParameterCount if it is set to false.
I personal prefer a).
Cheers,
Jan