ORA-01756 的问题

Question

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,)
)

Answer 1

对Oracle没有研究，估计是单引号导致的错误

Answer 2

sql执行起来是没有问题的,我试过了
你拼写的时候有没有问题呢?

Answer 3

晕,建议改写为 insert into CNVAD.error_log (....) values (...),如果有些列不需要插入,在建立表的时候指定默认值=0,免的写的密密麻麻,不好排撮

Answer 4

他总共才3个字段.最后一项是个long
我存道本机数据库是可以正确执行的
我是在 sql explorer执行的

Answer 5

可以试试：
1、是否有权限写？
2、可以型如： Insert Into Tab_Name(Field1,Field2,field3) Values(…………)
3、检查其他的VB语句是否有问题导致的
…………

Answer 6

第一：
双引号全替换成单引号
第二：
如果CNVAD代表另外一个用户，即不同于建立连接的用户，那么重新写连接语句，user=CNVAD，pass=?
建立新的连接后
INSERT INTO  error_log VALUES

Answer 7

另外请大家看看
http://expert.csdn.net/Expert/topic/2542/2542591.xml?temp=.5476343
共同探讨一下我的问题