ORA-01861: literal does not match format string
来源:互联网 发布:知乎如何添加话题 编辑:程序博客网 时间:2024/05/01 04:23
ORA-01861: literal does not match format string
一般来说这个错误是因为数据库语言照成格式化异常
首先查看你传输的数据的格式是否和数据库匹配
如果还不行在查看你数据的语言(查看数据的sql语句为 select * from v$nls_parameters )
[{PARAMETER=NLS_LANGUAGE, VALUE=AMERICAN},
{PARAMETER=NLS_TERRITORY, VALUE=AMERICA},
{PARAMETER=NLS_CURRENCY, VALUE=$},
{PARAMETER=NLS_ISO_CURRENCY, VALUE=AMERICA},
{PARAMETER=NLS_NUMERIC_CHARACTERS, VALUE=.,},
{PARAMETER=NLS_CALENDAR, VALUE=GREGORIAN},
{PARAMETER=NLS_DATE_FORMAT, VALUE=DD-MON-RR}, 这个标识数据库date类型的格式
{PARAMETER=NLS_DATE_LANGUAGE, VALUE=AMERICAN}, 看下此处的编码格式这个表示date类型的编码格式
{PARAMETER=NLS_CHARACTERSET, VALUE=JA16SJIS}, 还有次数的格式这个表示你数据库的字符编码格式
{PARAMETER=NLS_SORT, VALUE=BINARY}, {
PARAMETER=NLS_TIME_FORMAT, VALUE=HH.MI.SSXFF AM},
{PARAMETER=NLS_TIMESTAMP_FORMAT, VALUE=DD-MON-RR HH.MI.SSXFF AM},
{PARAMETER=NLS_TIME_TZ_FORMAT, VALUE=HH.MI.SSXFF AM TZR},
{PARAMETER=NLS_TIMESTAMP_TZ_FORMAT, VALUE=DD-MON-RR HH.MI.SSXFF AM TZR},
{PARAMETER=NLS_DUAL_CURRENCY, VALUE=$},
{PARAMETER=NLS_NCHAR_CHARACTERSET, VALUE=AL16UTF16},
{PARAMETER=NLS_COMP, VALUE=BINARY},
{PARAMETER=NLS_LENGTH_SEMANTICS, VALUE=BYTE},
{PARAMETER=NLS_NCHAR_CONV_EXCP, VALUE=FALSE}]
- ORA-01861: literal does not match FORMat string 错误原因
- Oracle异常ORA-01861: literal does not match format string。
- ORA-01861: literal does not match format string 错误!
- ORA-01861: literal does not match format string
- 关于ORA-01861: literal does not match format string
- Oracle 异常 ORA-01861: literal does not match format string
- Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- oracle学习笔记【 ORA-01861: literal does not match format string(字符串格式不匹配)】
- 解决:Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- 关于时间比较,ORA-01861: literal does not match format string
- 解决Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
- Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
- literal does not match format string 解决办法
- literal does not match format string
- Oracle 异常 ORA-01861: literal does not match form
- format not a string literal and no format arguments
- format not a string literal and no format arguments
- 场景编辑器中间状态的保存
- VC中在对话框上使用Rich Edit控件
- 各种Adapter的用法
- vim 使用技巧汇总
- 简单工厂模式
- ORA-01861: literal does not match format string
- Informix 11.5 新特性介绍tempdbs
- 求simatic net授权
- 12.c++-返回引用的函数
- Android异步加载图像小结
- RO39 – 在一个事务中实现多个ClientDataSets 更新
- startActivity的requires new task异常解析
- jQuery 写的仿新浪微博 向下滚动效果【转载】
- Castle-MVC框架显示层—nVelocity学习1