0 Replies Latest reply on May 26, 2006 1:36 PM by coldjava

    DataDirect 3.3 OEM Driver Error

    coldjava
      Hello,

      I tried to use DataDirect 3.3 OEM Driver like this:

      jrun-resources.xml

      <data-source>
      <dbname>Test_oracle</dbname>
      <driver>macromedia.jdbc.oracle.OracleDriver</driver>
      <url>
      jdbc:macromedia racle://host:1521;servicename=xxx </url>
      <username>user</username>
      <password>password</password>
      ......
      .....
      This is how I make JDBC calls and try to retrieve some data:


      stmnt = conn.prepareCall("{call package.storedproceudre(?)}")
      stmnt.registerOutParameter(1, OracleTypes.CURSOR);
      stmnt.execute();
      rs = (ResultSet) stmnt.getObject(1);

      I get this error:

      java.sql.SQLException: [Macromedia][Oracle JDBC Driver]The requested output parameter data is not available.
      at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
      at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
      at macromedia.jdbc.base.BaseCallableStatement.getAndValidateOutParameter(Unknown Source)
      at macromedia.jdbc.base.BaseCallableStatement.getObject(Unknown Source)
      at jrun.sql.JRunCallableStatement.getObject(JRunCallableStatement.java:128)

      Any ideas what I might be doing wrong.

      Thanks for your help in advance