> > /* ------------------------------------------------------------ */
> > CREATE PROCEDURE ADD_NEW_USER (
> > CID CHAR (8) CHARACTER SET WIN1251,
> > CNAME CHAR (30) CHARACTER SET WIN1251,
> > CPHONE CHAR (10) CHARACTER SET WIN1251,
> > CEMAIL CHAR (30) CHARACTER SET WIN1251,
> > CPSW CHAR (8) CHARACTER SET WIN1251)
> > AS
> >
> > BEGIN
> > BEGIN
> > INSERT INTO TBLCUST (CID, CNAME,CPHONE,CEMAIL,CPSW) VALUES
> > (:CID, :CNAME,:CPHONE,:CEMAIL,:CPSW);
> > END
> > SUSPEND;
> > END
> > /* ------------------------------------------------------------ */

In addition to Alans answer, just a note:
do NOT use "suspend" in a procedure that doesn't need to return
data via a SELECT.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com