建存储过程报语法错误，求救~~~~

[humdark]

CREATE PROCEDURE "jjxt".smkgjjgx(c_cdno CHAR(16)
delete from tbcardaccount where cardno=c_cdno;
insert into tbcardaccount select b.cardno, b.iccard, a.fbankid, a.faccno,
b.name, b.certificateid, f.faccstate from acperson a, tunbusicard b
where b.cardno = c_cdno and
(a.fid = b.certificateid or
a.fid = b.certificateid[1,6]||b.certificateid[9,17]);
END PROCEDURE;
在isql里用sql运行的时候报：201: A syntax error has occurred.
请高手指点。

[humdark]

问题依然存在，各位大虾帮忙啊

[humdark]

问题很急，分不够我可以再加

[luoxq_263]

select语句对吧？另外就是tbcardaccount内容是否同select出来是否一直呢？

[luoxq_263]

CREATE PROCEDURE "jjxt".smkgjjgx(c_cdno CHAR(16)) --少了一个')'
delete from tbcardaccount where cardno=c_cdno;
insert into tbcardaccount select b.cardno, b.iccard, a.fbankid, a.faccno,
b.name, b.certificateid, f.faccstate from acperson a, tunbusicard b
where b.cardno = c_cdno and
(a.fid = b.certificateid or
a.fid = b.certificateid[1,6]||b.certificateid[9,17]);
END PROCEDURE;

[humdark]

不好意思
这个是我打错了