This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
shyam prasad prasad
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shyam,
It sounds like the code doesn't match the database. If you want more specific advice, please share some code.
 
Ustat Sevindik
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 50241
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Ustat Ustat" please read the important administrative private message I just sent you.

CR
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic