An Oracle stored procedure does not return a ResultSet by default. You need to define a stored procedure in a specific way in order to make it return a ResultSet. Bruce P. Blackshaw provides a great example in a paper titled Returning a JDBC result set from an Oracle stored procedure at http://www.enterprisedt.com/publications/oracle/result_set.html. The stored procedure call must be set up using the function syntax, for example:
{ ? = call myOracleProcedure (?, ?) }Note the leading “? =“, which indicates that a value is returned. You might consider wrapping existing stored procedures with procedures that can format the results in a manner that the ATG SQL repository requires.
