执行SQL语句时报的错误,SQL如下:
insert into portal_sync_dpt_recorder (id,ou, ctOrgType, name, displayname, ctInitial, description, mail, postalAddress, postalCode, l,
ctBusinessCategory, ctOrgManager, ctViceManager, ctOrder, ctSupervisorydepartment, ctReportingdepartment, ctStatus,sendTime, changetype,insertTime, dealstatus)
values (seq_portal_sync_dpt_recorder.nextval,'2915120000','2','济南财务部','济南财务部','','山东-济南财务部','','','','山东-济南','','wangysh','weiyupeng',' ',
'ouu003d2915000000,cnu003dorganizations,DCu003dsd,DCu003dctc,DCu003dCOM','2915000000','1',to_timestamp('2011-11-10 10:24:12','yyyy-mm-dd hh24:mi:ss.ff3') ,
'update',to_timestamp('2011-11-16 14:28:11','yyyy-mm-dd hh24:mi:ss'),0)执行SQL的时候报了ora-01722错误,说标红的地方为无效数字,其对应的字段为varchar2类型,请大侠们指教
insert into portal_sync_dpt_recorder (id,ou, ctOrgType, name, displayname, ctInitial, description, mail, postalAddress, postalCode, l,
ctBusinessCategory, ctOrgManager, ctViceManager, ctOrder, ctSupervisorydepartment, ctReportingdepartment, ctStatus,sendTime, changetype,insertTime, dealstatus)
values (seq_portal_sync_dpt_recorder.nextval,'2915120000','2','济南财务部','济南财务部','','山东-济南财务部','','','','山东-济南','','wangysh','weiyupeng',' ',
'ouu003d2915000000,cnu003dorganizations,DCu003dsd,DCu003dctc,DCu003dCOM','2915000000','1',to_timestamp('2011-11-10 10:24:12','yyyy-mm-dd hh24:mi:ss.ff3') ,
'update',to_timestamp('2011-11-16 14:28:11','yyyy-mm-dd hh24:mi:ss'),0)执行SQL的时候报了ora-01722错误,说标红的地方为无效数字,其对应的字段为varchar2类型,请大侠们指教
解决方案 »
- oracle断电后无法启动,提示ora-00600[6006]错误,菜鸟请大侠指教
- oci 里的 OCILobGetLength 为什么不准??
- dbms_datapump导出dmp文件时NAME_LIST的长度超过了4000该怎么办
- 在AIX环境实际应用下,对于应用的oracle,平时最容易发生的问题大致有哪些?(只列出常见问题即可,不用作答,回答更加感谢)
- 在命令行中启动oracle8i需要配置环境变量吗
- OraSession问题
- 求救,一个sqlserver中运行的正常的更新语句在oracle中运行报错“sql命令未正确结束”
- NULL 与列值比较 急急!!!
- 【急】在oracle中怎么从时间中得到单独年、月、日!
- 提取本地所有表某一天的数据压缩成文件上传到远程服务器怎么实现?(在线等待)
- 谁来远程教教我如何使用oracle, 我只会sql语句..
- oracle 函数和存储过程的用法
怎么解决的?说来大家也了解下
CTBUSINESSCATEGORY VARCHAR2(100), CTORGMANAGER VARCHAR2(100), CTVICEMANAGER VARCHAR2(100), CTORDER VARCHAR2(100), CTSUPERVISORYDEPARTMENT VARCHAR2(100), CTREPORTINGDEPARTMENT VARCHAR2(100), CTSTATUS VARCHAR2(100),SENDTIME VARCHAR2(100), CHANGETYPE VARCHAR2(100),INSERTTIME VARCHAR2(100), DEALSTATUS VARCHAR2(100))
insert into portal_sync_dpt_recorder (id,ou, ctOrgType, name, displayname, ctInitial, description, mail, postalAddress, postalCode, l,
ctBusinessCategory, ctOrgManager, ctViceManager, ctOrder, ctSupervisorydepartment, ctReportingdepartment, ctStatus,sendTime, changetype,insertTime, dealstatus)
values (1,'2915120000','2','济南财务部','济南财务部 ','','山东-济南财务部','','','','山东-济南','','wangysh','weiyupeng',' ',
'ouu003d2915000000,cnu003dorganizations,DCu003dsd,DCu003dctc,DCu003dCOM','2915000000','1',to_timestamp('2011-11-10 10:24:12','yyyy-mm-dd hh24:mi:ss.ff3') ,
'update',to_timestamp('2011-11-16 14:28:11','yyyy-mm-dd hh24:mi:ss'),0)1 行已插入。照抄你的sql也能正常执行,没有任何问题