0 Replies Latest reply on Oct 14, 2004 9:49 PM by Rajeev Chitamoor

    Returning a JDBC result set from an Oracle stored procedure

    Rajeev Chitamoor Newbie

      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.