Hello

Iam using jdk 1.2.2 and jdbc 1.1 Iam calling a stored procedure in the java code which returns a cursor. When I use the registerOutParameter, I get the following error:
SQLException : java.sql.SQLException: Invalid column type

The java code at which the error is thrown is as follows:
callStmt.registerOutParameter(1,Types.OTHER);


The complete error log shown on the weblogic console is as follows:

SQLException : java.sql.SQLException: Invalid column type
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:269)
        at oracle.jdbc.driver.OracleStatement.get_internal_ty pe(OracleStatement.
java:6383)
: at oracle.jdbc.driver.OracleCallableStatement.registe rOutParameterBytes(
OracleCallableStatement.java:244)
        at oracle.jdbc.driver.OracleCallableStatement.registe rOutParameter(Oracl
eCallableStatement.java:393)
        at oracle.jdbc.driver.OracleCallableStatement.registe rOutParameter(Oracl
eCallableStatement.java:462)
        at weblogic.jdbc.pool.Statement.registerOutParameter( Statement.java:640)


Plsss help me

Strange enough all the Types defined in java.sql.types are not recognized by the Oracle Implementation of the CallableStatement

Hereafter is the list of the values accepted by the "get_internal_type" method

SQL External Type | Oracle Internal Type
------------------|---------------------
     -7 | 6
     -6 | 6
     -5 | 6
     2 | 6
     3 | 6
     4 | 6
     5 | 6
     6 | 6
     7 | 6
     8 | 6
------------------+---------------------
     999 | 999
------------------+---------------------
     1 | 96
------------------+---------------------
     12 | 1
------------------+---------------------
     -1 | 8
------------------+---------------------
     91 | 12
     92 | 12
     93 | 12
------------------+---------------------
     -3 | 23
     -2 | 23
------------------+---------------------
     -4 | 24
------------------+---------------------
     -8 | 104
------------------+---------------------
     2004 | 113
------------------+---------------------
     2005 | 112
------------------+---------------------
     -13 | 114
------------------+---------------------
     -10 | 102
------------------+---------------------
     2002 | 109
     2003 | 109
------------------+---------------------
     2006 | 111
------------------+---------------------
     -14 | 998
------------------+---------------------


As you can see neither Types.OTHER (1111) nor Types.JAVA_OBJECT are valid SQL Types for this method