I use Oracle with WebObjects. I have not seen this type of error.
What are you trying to do specifically? Do you have any code? Send
me the datatype and field name. How are you trying to manage the
timezone.
Thanks
Don
On Dec 14, 2009, at 5:23 AM, Andrew Lindesay wrote:
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/pccdonl
%40mac.com
This email sent to pccd...@mac.com
_______________________________________________
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