Re: Problem with JDBC-Type 4 and Linux

Peter Kroiss wrote:
> I often get an unrepeatable error "Refcursor value is invalid" from my
> jdbc-driver (Oracle) type 4
> The statements are not always the same and I cannot repeat this
> error. Most of the times the statements, which are very simple, are
> working fine, but sometimes I get this error.
> The same happens with "java.sql.SQLException: Bigger type length
> than Maximum".
> I already search the knowledge base at metalink.oracle.com, the only
> thing I found is that others
> also have the same problems but I didn't finde a patch or a reason why
> these error occur.
> I'm using Oracle 8.1.7 on Linux RedHat. We are using the O/R-Mapping
> Tool TopLink.
> Does anybody have a solution for this?
> Peter
> Throwable: java.sql.SQLException
> message: Refcursor value is invalid
> java.sql.SQLException: Refcursor value is invalid
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
> at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)
> at oracle.jdbc.ttc7.TTCStatement.<init>(TTCStatement.java:41)
> at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:469)
> at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
> at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)
> at
> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedSt-
> atement.ja
> va:182)
> at
> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedSt-
> atement.ja
> va:183)
> at
> oracle.jdbc.driver.OracleConnection.privatePrepareStatement(Oracle-
> Connection
> .java:604)
> at
> oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnect-
> ion.java:4
> 85)

Hi Peter,

I am also facing the same problem.Do you have any solution for this?

Thanks in advance, -Bharat

--
Posted via dBforums
http://dbforums.com