java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
来源:互联网 发布:js字符串数字相加 编辑:程序博客网 时间:2024/05/17 07:50
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY 这个异常翻译为中文:java.sql.SQLException: 不一致的数据类型:预期得到的二进制数.
出现这个原因就是数据库查出的数据类型和你在程序中要用的数据类型(或者是转换的数据类型)不一致导致.或者是你数据查出来是null,或者是你在查数据库时查询条件为空了,没有办法查询了.
步步前进.
0 0
- java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
- ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
- ORA-00932: inconsistent datatypes: expected - got CLOB
- ORA-00932: inconsistent datatypes: expected - got CLOB
- ORA-00932: inconsistent datatypes: expected - got CLOB
- ORA-01704: string literal too long 和 ORA-00932: inconsistent datatypes: expected NUMBER got LONG
- ORA-00932: inconsistent datatypes: expected NUMBER got INTERVAL DAY TO SECON
- inconsistent datatypes: expected DATE got NUMBER
- ORA-00932: inconsistent datatypes: expected
- ORA-00932: inconsistent datatypes
- 【ERROR】java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BINARY
- java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 BINARY 解决
- java.sql.SQLException: ORA-00923: FROM keyword not found where expected
- Exception in thread "main" java.sql.SQLException: ORA-00923: FROM keyword not found where expected
- java.sql.SQLException: Wrong number of parameters: expected 0, was given 1 Query:
- java.sql.SQLException: OALL8 is in an inconsistent state.
- java.sql.SQLException: ORA-08102
- java.sql.SQLException: ORA-01428
- Objective-C相关Category
- What exactly is null in Java?[转]
- Yale CAS + .net Client 实现 SSO(1)
- CentOS 5.x和CentOS 6.x限制单个用户线程数上限的不同行为
- STM32 Printf函数实现方法
- java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
- VS TRACE的使用
- Yale CAS + .net Client 实现 SSO(2)
- NativeActivity通过jni调用java层的Android API
- 房地产售楼处神秘顾客调研方案
- ffmpeg 新旧版本AVFrame中data的yuv颠倒
- AWK 学习(一) 基础归纳
- NSDate 获取某个日期之前的日期
- Why do you need to put #!/bin/bash at the beginning of a script file?