Oracle's RefCursDemo.sqlj is in error.

From: Hang <heilongjiang>
Date: Mon, 29 Apr 2002 23:08:26 +0800
Message-ID: <3ccd6189$1_at_news.starhub.net.sg>

Hi,

    Has anybody tried the RefCursDemo supplied with Oracle8iEE (8.1.5).     I have Windows2000, Oracle8iEE (8.1.5) with JDK1.1.8     But compiling and running the REF CURSOR DEMO gives me this error.

    I have tried earlier with my own SQLJ program and got similar error
:

        invalid column type : get internal type

    I thought it's my coding error, so I tried Oracle's own Demo.     Even Oracle's code has the same problem!     Anybody got any idea what's wrong?

    Thanks for any light on this.
    Much appreciated!

---

---

---

C:\ora\2>java RefCursDemo
Using anonymous block for ref cursor..
java.sql.SQLException: Invalid column type: get internal type

        at oracle.jdbc.dbaccess.DBError.check error(DBError.java:422)
        at 

oracle.jdbc.driver.OracleStatement.get internal type(OracleStatement.java
:3013)

        at
oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCal lableS
tatement.java:164)

        at
oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCal lableS
tatement.java:147)

        at
sqlj.runtime.profile.ref.RTStatementJDBCCallable.registerOutParameter(RTS tateme
ntJDBCCallable.java:66)

        at
sqlj.runtime.profile.ref.ParamRegProfile.getStatement(Compiled Code)

        at
sqlj.runtime.profile.ref.PositionedProfile.getStatement(PositionedProfile .java:
111)

        at
sqlj.runtime.profile.ref.TransactionControlProfile.getStatement(Transacti onCont
rolProfile.java:125)

        at
sqlj.runtime.ExecutionContext$StatementStack.setStatement(ExecutionContex t.java
:614)

        at
sqlj.runtime.ExecutionContext.registerStatement(ExecutionContext.java:280 )

        at RefCursDemo.refCursInAnonBlock(RefCursDemo.java:91)
        at RefCursDemo.main(RefCursDemo.java:55)

--

Received on Mon Apr 29 2002 - 17:08:26 CEST