I need to call an oracle stored procedure which returns a PL/SQL TABLE data type (OUT parameter). In the parameter tab of the adapter service, I selected “OTHER” as the JDBC type and “java.lang.Object” as the java type for this parameter. It displays an “Invalid Column type” exception when I run this adapter service.
How do I get Table type in my service. My requirement is to return an array of strings from Oracle stored procedure. Any help will be appreciated.