cx_Oracle.DatabaseError: ORA-00911: invalid character
来源:互联网 发布:乘联会销量数据suv 编辑:程序博客网 时间:2024/05/20 08:23
本文转载自:http://python.6.x6.nabble.com/CPyUG-python-insert-oracle-td2740346.html
SQL如下:
INSERT INTO WEB_REPORT_TEST2(d_tid,d_type,d_uv,d_pv,d_ip,d_hour) values(110556,1,1,12,1,0) ;
Python代码如下:
SQL = "INSERT INTO "+TABLE_NAME+"(d_tid,d_type,d_uv,d_pv,d_ip,d_hour) values("+str(k)+','+str(D_TYPE)+','+str(v.get('uv'))+','+str(v.get('pv'))+','+str(v.get('ip'))+','+str(time_point)+''")"print SQLcu.execute(SQL)
在sqlplus中执行正常。
在python中则出现:
cx_Oracle.DatabaseError: ORA-00911: invalid character
搜索了一下,说是;的问题,去掉后报错如下:
cx_Oracle.DatabaseError: ORA-00972: identifier is too long
0 0
- cx_Oracle.DatabaseError: ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character错误
- ORA-00911: invalid character的解决办法
- SQL EXCEPTION ORA-00911: invalid character
- ORA-00911: invalid character的解决办法
- java.sql.SQLException: ORA-00911: invalid character
- java.sql.SQLException: ORA-00911: invalid character
- ORA-00911: invalid character问题解决办法
- ORA-00911: invalid character 解决方法(转)
- ORA-00911: invalid character 的问题处理
- ORA-00911: invalid character的解决办法
- ORA-00911: invalid character 错误解决
- cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred错误处理一则
- 模拟IC流片经验分享
- android 监听数据库ContentObserver使用说明
- 僵尸进程Zombie process
- ActionBarDrawerToggle 使用小结
- 安卓中文本视图TextView的扩展使用
- cx_Oracle.DatabaseError: ORA-00911: invalid character
- SYSTEMTAP安装
- MFC 控件字体样式和颜色设置
- yum出现的错误
- tomcat7连接池使用
- C++学习笔记
- mysql 权限设置
- AspNetPager控件的用法
- Java并发编程-19-在执行器中延时执行任务和周期性执行任务