Bug #34941 Tableadapter for a stored procedure doesnt recognize parameters VS2008

Submitted:	28 Feb 2008 20:56	Modified:	1 Mar 2008 10:18
Reporter:	Mike Hat	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	5.2.1	OS:	Windows (VS2008)
Assigned to:		CPU Architecture:	Any

Description:
When adding a tableadapter for a stored procedure it doesnt recognize the parameters. 

I get an error saying:

"Generated SELECT statement
       Parameter '@sarasa' not found in the collection."

for the following stored procedure

PROCEDURE StoredProcedure3 (sarasa int)
BEGIN
SELECT colmena.colmena_id,  apiario.ubicacion FROM colmena  LEFT JOIN apiario ON colmena.apiario_id = apiario.apiario_id WHERE apiario.apiario_id = sarasa;
END

This was working fine on 5.1.4 (after the parameter bugfix)

How to repeat:
Create a stored procedure with a parameter

create a dataset and a table adapter for the stored procedure.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/43225

Fixed in 5.2.2

A note has been added to the 5.2.2 changelog: 

Using the TableAdapter Wizard would fail when generating commands that used stored procedures due to the change in supported parameter characters.

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.