Invalid column type from jdbc...

From: alan <alanbrown_at_pacbell.net>
Date: Mon, 13 Jan 2003 20:15:47 GMT
Message-ID: <T7FU9.20$Gt7.1226983@newssvr17.news.prodigy.com>

I'm not sure if this is the right group to post in, but I've been having a problem trying to get oracle callable statements working in Java. The code used to work in a different environment but something is different now and I'm not sure what it is. The stack trace I'm getting is...

java.sql.SQLException: Invalid column type

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)

at
oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:61 64)
at
oracle.jdbc.driver.OracleCallableStatement.registerOutParameterBytes(OracleC allableStatement.java:244)
at
oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallab leStatement.java:393)
at

oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallab
leStatement.java:462)
at weblogic.jdbc.pool.Statement.registerOutParameter(Statement.java:617)

and the java code that's spawning the error is...

    weblogic.jdbc.common.OracleCallableStatement cs = null;

    try {
      cs =
(weblogic.jdbc.common.OracleCallableStatement)con.prepareCall(get_tasks);

      cs.registerOutParameter(1, java.sql.Types.OTHER);
      .... etc. etc...

the code crashes at that last line.

any thoughts would be much appreciated...

alan Received on Mon Jan 13 2003 - 14:15:47 CST