Skip navigation links

MySQL Forums :: Connector/C++ :: c++ mysql stored procedure error code 1064, SQLState: 42000


Advanced Search

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 1188 Mirza Alex 05/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.