When configuring an adapter service for the JDBC Adapter, I notice that, on the Parameter Tab, column Param JDBC Type, one of the possible type selections is ORACLECURSOR. I also notice that, if that choice is selected, no parameters appear in either the input or output names on the screen below (or in the Input/Output section.
Does anyone know what this is about? How it works?
Is it possible to pass an ORACLECURSOR as a procedure parameter and actually use it.
Since there is no variable name created in Input/Output section for the cursor, how is it accessed?
Any help or ideas will be appreciated.