wood burning stoves 2.0*
The moose likes JDBC and the fly likes er for Oracle][Oracle]ORA-00932: inconsistent datatypes: expecte NUMBER got BINARY Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "er for Oracle][Oracle]ORA-00932: inconsistent datatypes: expecte NUMBER got BINARY" Watch "er for Oracle][Oracle]ORA-00932: inconsistent datatypes: expecte NUMBER got BINARY" New topic
Author

er for Oracle][Oracle]ORA-00932: inconsistent datatypes: expecte NUMBER got BINARY

shyam prasad prasad
Greenhorn

Joined: Sep 18, 2008
Posts: 5
thanks

hai iam inserting images to oracle but my code was complied,it was shown an error while iam running

java.sql.SQLException: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00932: inc
onsistent datatypes: expected NUMBER got BINARY
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

Shyam,
It sounds like the code doesn't match the database. If you want more specific advice, please share some code.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Ustat Sevindik
Greenhorn

Joined: Jun 15, 2006
Posts: 2
One of the following:

An attempt was made to perform an operation on incompatible datatypes. For example, adding a character field to a date field (dates may only be added to numeric fields) or concatenating a character field with a long field.

An attempt was made to perform an operation on a database object (such as a table or view) that is not intended for normal use. For example, system tables cannot be modified by a user. Note that on rare occasions this error occurs because a misspelled object name matched a restricted object's name.

An attempt was made to use an undocumented view.

Source : AllAboutOracle.com

If you need to query oracle errors and their explanations directly, you can use AllAboutOracle.com like me.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 37962
    
  22
"Ustat Ustat" please read the important administrative private message I just sent you.

CR
 
 
subject: er for Oracle][Oracle]ORA-00932: inconsistent datatypes: expecte NUMBER got BINARY
 
Similar Threads
Number to big decimal mapping problem in CMP
java.sql.BatchUpdateException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
JdbcRowSet - setTypeMap error?
JDBC Problem with Date insertion
ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8