MySQL Forums
Forum List  »  Stored Procedures

Stored Procedures in ASP.NET VB troubles, please help
Posted by: Gert
Date: September 10, 2005 03:01AM

My goal is to do a SQL update command with a variable. But because of the errors I get I just made it a select statement. But even that gives an error.

cmd.Connection = conn

cmd.CommandText = "CREATE PROCEDURE gert (OUT param1 INT) BEGIN SELECT *
FROM tabel1; END"

cmd.ExecuteNonQuery()

Please help, whatever sql statement I use I allways get this error

Error 1064 #42000You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'PROCEDURE gert (OUT param1 INT) BEGIN SELECT * FROM tabel1; END' at line 1

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored Procedures in ASP.NET VB troubles, please help
2414
September 10, 2005 03:01AM


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.