[STRATEGIC] [OJDBC] ERROR: TypeError: Cannot find function registerOutParameter in object DynamicWrapper (Instance) : [PreparedStatement]-[interface java.sql.PreparedStatement] – VALUE : oracle.jdbc.driver.OracleCallableStatementWrapper@#######
VMware Aria Automation 8.18.1
VMware Aria Automation Orchestrator SQL plugin
After upgrading to Aria Automation Orchestrator 8.18.1, workflows using Oracle JDBC CallableStatement fail due to a change in how the scripting engine treats the relationship between PreparedStatement
and CallableStatement
.
prepareCall()
function correctly returned a CallableStatement
object, allowing the use of registerOutParameter()
.prepareCall()
incorrectly returns a PreparedStatement
instead of a CallableStatement
, causing workflows to fail when calling registerOutParameter()
.VMware is aware of this issue and a fix is being considered for inclusion in a later patch. [8.18.1 P2]
For further updates, please refer to this article or contact Broadcom support.