Oracle 9.0 在vb中利用oo4o ExecuteSQL执行sql语句 报ORA-01756,但用sqlplus执行通过,求解决方法.
sql语句:
INSERT INTO CNVAD.error_log VALUES ( 393 , 335 ,
''' '',''PEAS1 '','' '','' '',''200103'','' '','' '',''52'',
''1'','' '',''DIR001'',''A100'','' '','' '','' '','' '',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''27'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''NENKIN'',
''20010831''' )CREATE TABLE CNVAD.ERROR_LOG
(
EXEC_NO NUMBER NOT NULL,
RECORD_NO NUMBER NOT NULL,
ERR_RECORD LONG,
CONSTRAINT PK_ERROR_LOG PRIMARY KEY (EXEC_NO, RECORD_NO,)
)
sql语句:
INSERT INTO CNVAD.error_log VALUES ( 393 , 335 ,
''' '',''PEAS1 '','' '','' '',''200103'','' '','' '',''52'',
''1'','' '',''DIR001'',''A100'','' '','' '','' '','' '',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''27'',''0'',''0'',''0'',
''0'',''0'',''0'',''0'',''0'',''0'',''0'',''NENKIN'',
''20010831''' )CREATE TABLE CNVAD.ERROR_LOG
(
EXEC_NO NUMBER NOT NULL,
RECORD_NO NUMBER NOT NULL,
ERR_RECORD LONG,
CONSTRAINT PK_ERROR_LOG PRIMARY KEY (EXEC_NO, RECORD_NO,)
)
解决方案 »
- █▄看似简单但很复杂的经典网络问题▄█
- VB里面如何实现放大、旋转
- 我用form做的报表!!如何把它转化为html格式的文件?问题解决至少加40
- 求Setup Factory V6.03 安装密码
- 如何实现对z4m打印机编程,急
- 送给大家一个源码,帮我找找里面的找图函数是怎么定义的
- 关于ADO的问题,请教一下!
- win2000做网关,(两快网卡,1卡接通宽带,1卡接局欲网),但怎样限制客户机.
- 如何实现整库拷贝,在access中
- 挥泪给分、:) 如何将本地的某一目录设置为网络共享。要求有用户名及密码。
- 如何在TRUE Dbgrid表格中进行编辑及从下拉列表中选择?
- 有没有办法在VB里面捕捉word里面的事件,例如打开,关闭等……
你拼写的时候有没有问题呢?
我存道本机数据库是可以正确执行的
我是在 sql explorer执行的
1、是否有权限写?
2、可以型如: Insert Into Tab_Name(Field1,Field2,field3) Values(…………)
3、检查其他的VB语句是否有问题导致的
…………
双引号全替换成单引号
第二:
如果CNVAD代表另外一个用户,即不同于建立连接的用户,那么重新写连接语句,user=CNVAD,pass=?
建立新的连接后
INSERT INTO error_log VALUES
http://expert.csdn.net/Expert/topic/2542/2542591.xml?temp=.5476343
共同探讨一下我的问题