在pb中运行execute immediate :ls_str;出错

[huishen]

string ls_str
ls_str = "'insert into IC_CJ_XHD(djbh,djrq,verzxbh,gzzxbh,scpc,cpbh,cpsl,cpdj,jjwlbh,jjwlsl,wlbh,wllb,dwsl,llsl,wldj,shr,zdr,shrq,bz,djlb,jszxbh,qtbz,cbxm,dybh,clyy,xh) values('200408030001','20040803','017821','0','10','C1J;FWB00;12Cr1MoV;168*14',0,0,'0',0,'0','O21',0,0,0,'2486','0','0','20040803 10:00:30','0','0','0','ch','0','0','0')';"
execute immediate :ls_str;

提示错误
ORA-01043: 用户方内存损坏 []、[]、[]、[]

怎么回事啊

[10975037]

注意一点，在pb中写sql 语句要加 分号，在sqlserver ,oracle 中不用加
-----------------------------------------------------------------------
SQLCA.AutoCommit = true
string ls_str
ls_str = "insert into IC_CJ_XHD(djbh,djrq,verzxbh,gzzxbh,scpc,cpbh,cpsl,cpdj,jjwlbh,jjwlsl,wlbh,wllb,dwsl,llsl,wldj,shr,zdr,shrq,bz,djlb,jszxbh,qtbz,cbxm,dybh,clyy,xh) values('200408030001','20040803','017821','0','10','C1J;FWB00;12Cr1MoV;168*14',0,0,'0',0,'0','O21',0,0,0,'2486','0','0','20040803 10:00:30','0','0','0','ch','0','0','0')"
execute immediate :ls_str using sqlca ;
SQLCA.AutoCommit = false

[SilverSands]

你把SQL拿到数据库执行，没有错误，再在PB上找问题

[鸡翅多]

你的sql语句最后不要加“；”

[huishen]

insert into IC_CJ_XHD(djbh,djrq,verzxbh,gzzxbh,scpc,cpbh,cpsl,cpdj,jjwlbh,jjwlsl,wlbh,wllb,dwsl,llsl,wldj,shr,zdr,shrq,bz,djlb,jszxbh,qtbz,cbxm,dybh,clyy,xh) values ('200408030002','20040803','017821','0','10','C1J;FWB00;12Cr1MoV;168*14',0,0,'0',0,'0','O21',0,0,0,'2486','0','0','20040803 11:29:26','0','0','0','ch','0','0','0');

在sqlplus中执行,为何提示无效字符阿?

[haisha]

你的sql语句里面用到了"；",请把分号改为道号