Hi team! I need to use the Java Action ExecuteCallableStatement from module Database Connector to call a stored procedure at an Oracle database with an output parameter of type ParameterRefCursor. How can I iterate with the Oracle Cursor represented by the ParameterRefCursor to get the result of the stored procedure and then convert it to an entity list in Mendix? Follow images from the ParameterRefCursor and the ExecuteCallableStatement: Thanks in advance for your support!
Juliano Custódio Parreira
Have you tried simple loop? Does it give any error?
The result should be a list so any standard traversal activiteis should be doable.