MySQL Forums
Forum List  »  Connector/C++

c++ mysql stored procedure error code 1064, SQLState: 42000
Posted by: Mirza Alex
Date: May 06, 2012 12:16PM

I use FreeBsd 8.0 amd64 and this package mysql-client-5.1.61, mysql-connector-c++-1.1.0, mysql-server-5.1.61 and gcc 4.2.1

I have this procedure
CREATE PROCEDURE add() begin
DECLARE vEvId int DEFAULT 0;
insert into ev(evDen,adr) values('concurs informatic 3','0'); select last_insert_id() into vEvId; END;

and when i try to run this from c++ program i get this error
# ERR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add' at line 1 (MySQL error code: 1064, SQLState: 42000 )

Options: ReplyQuote


Subject
Views
Written By
Posted
c++ mysql stored procedure error code 1064, SQLState: 42000
2833
May 06, 2012 12:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.