Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

# ORA-00932: inconsistent datatypes: expected %s got %s

620752Jul 18 2008
Hi,
we've got into the serious problem. In embedded OC4J, whole application works perfect. But when deployed on IAS, we get this error:

1. JBO-27122: SQL error during statement preparation. Statement: SELECT d.MON_POINT_ID AS MON_POINT_ID, d.MEAS_DATE AS MEAS_DATE, d.DATA AS DATA, d.STATUS AS STATUS, d.CREATED_ON AS CREATED_ON, d.CREATED_BY AS CREATED_BY, d.MODIFIED_ON AS MODIFIED_ON, d.MODIFIED_BY AS MODIFIED_BY, d.DATA_TYPE AS DATA_TYPE FROM seov.DAILY_DISCHARGE d
2. ORA-00932: inconsistent datatypes: expected %s got %s

and columns in ADF table with date and number datatypes are corrupted:
date is e.g. 15.11.5248 and value 6 is displayed as -5045000000000000000000000000

Could you help us?
Thanks in advance,
Peter Miklos
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2008
Added on Jul 18 2008
0 comments
557 views