Re: Oracle's RefCursDemo.sqlj is in error.

From: Hang <heilongjiang>
Date: Tue, 30 Apr 2002 16:12:37 +0800
Message-ID: <3cce5194_at_news.starhub.net.sg>

Hi,

    OK, can forget about this issue now 'cos I've got it fixed.

  "Hang" <heilongjiang _at_hotmail.com> wrote in message news: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 Tue Apr 30 2002 - 10:12:37 CEST