stored procedure

[Gert]

How do I call the stored procedure

 

[Paul Clement]

¤ How do I call the stored procedure
¤

There is an example in the documentation:

http://dev.mysql.com/doc/mysql/en/connector-net-using-stored.html#connector-net-using-stored-calling


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Sahil Malik [MVP]]

SqlCommand object, CommandType.StoredProcedure.

 

[Gert]

The following error occurs after this. What is wrong ?

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 add_emp(IN fname VARCHAR(20)) BEGIN SELECT * FROM KLANTEN; END'
at line 1



Dim conn As New MySql.Data.MySqlClient.MySqlConnection

Dim cmd As New MySql.Data.MySqlClient.MySqlCommand

conn.ConnectionString = myconnstring

Try

conn.Open()

cmd.Connection = conn



cmd.CommandText = "CREATE PROCEDURE add_emp(" _

& "IN fname VARCHAR(20)) " _

& "BEGIN SELECT * FROM KLANTEN; END"

cmd.ExecuteNonQuery()

Catch ex As MySql.Data.MySqlClient.MySqlException

Label1.Text = "Error " & ex.Number & " " & ex.Message

End Try