Hello;
I'm communicating with an Oracle database through an EOF model.
It is working well except that I get this trace logging coming through when
timestamp attributes are being SELECT'ed on;
SQLState(65000) vendor code(6502)
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_UTILITY", line 102
ORA-06512: at line 1
at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:132)
at
oracle.jdbc.driver.DatabaseError.createSqlException(DatabaseError.java:185)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:438)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at
oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at
oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at
oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4693)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
at oracle.sql.TRANSDUMP.getTransitions(TRANSDUMP.java:79)
at oracle.sql.TIMEZONETAB.updateTable(TIMEZONETAB.java:548)
at
oracle.jdbc.driver.OracleStatement.getDefaultTimeZone(OracleStatement.java:5831)
at
oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:17474)
at
oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:17951)
at
oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3014)
at
oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2247)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
at
com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:263)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
...
The fetch still works fine, but this problem is consuming some capacity and I
don't know why. It seems to be invoking a stored-procedure to fiddle timezones.
If I create a simple java program to fetch some data, I don't see this.
Has anybody else seen this one?
cheers.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
