I work on a scenario which returns data from a JDBC Receiver Adapter from a Stored Procedure. The Database is Oracle 9i.
Calling a Stored Procedure with simple Input and Output Parameters seems to be no problem, but i encounter problems with lists of data (Resultsets).
Oracle offers e.g. to return a list of data via self defined Objects/Records packed into a table type. Its no problem to do that with JDBC, but as the JDBC Adapter only supports basic SQL Types, it s not possible that way.
The online help (http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm)
describes
".. The results within the stored procedure are returned either as a table or .."
So it should be possible to return multiple elements as a table.
Did anyone find a workaround for how to do this?
Researching throug sdn i also found this thread:
sql-stored-procedure-returning-cursors-in-xi-30
There's a descritpion about using cursors for return a resultset. Did anyone try this..what Output Type is then needed for the Cursor as "Cursor" doesn't exist as SQL Type in the JDBC Adapter?
Greetz
Sebastian