Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl' is not defined
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
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.