MySQL Forums
Forum List  »  Stored Procedures

Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl' is not defined
Posted by: Steven Bunnell
Date: December 01, 2005 06:36PM

I'm having a problem getting parameters working.

Mysql 5.0.16
mysql-connector-net-1.0.7
VB.NET 1.1

mysql> SHOW CREATE PROCEDURE tbl_slct \G
*************************** 1. row ***************************
Procedure: tbl_slct
sql_mode:
Create Procedure: CREATE PROCEDURE `tbl_slct`(IN tbl CHAR(64))
READS SQL DATA
BEGIN
SET @s = CONCAT('SELECT * FROM ' , tbl);
PREPARE stmt FROM @s;
EXECUTE stmt;
END
1 row in set (0.00 sec)

Public Function Test() As DataTable
If myConn.State <> ConnectionState.Open Then
myConn.ConnectionString = myConnString
myConn.Open()
End If

Test = New DataTable

Dim myCmd As New MySql.Data.MySqlClient.MySqlCommand("tbl_slct", myConn)
myCmd.CommandType = CommandType.StoredProcedure

myCmd.Parameters.Clear()
myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter("&tbl", "escdofficer"))
myCmd.Parameters("&tbl").Direction = ParameterDirection.Input

Dim myAdapter As New MySqlDataAdapter(myCmd)
myAdapter.Fill(Test) '*** raises MySqlException
End Function

"Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl' is not defined"

What am I missing?

Thanks,
Steve

Options: ReplyQuote


Subject
Views
Written By
Posted
Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl' is not defined
2673
December 01, 2005 06:36PM


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.