I am trying to retrieve a REFCURSOR from an Oracle PL/SQL store proc from my DAO running in JBoss 3.2.5.
I get a " ORA-01403: no data found" exception at the statement
CallableStatement.getObject(x); // where X is a column that represents
// a result set
I did verify that the store proc does return data.
This was working in 9i, but as soon as we switched to 10g,
it stopped working. However I don't see this problem with the 10g Thin driver,
it only happens with the 10g OCI driver.
Any help would be appreciated.