Bug #12576 White Space in parameter list
Submitted: 15 Aug 2005 3:45 Modified: 15 Aug 2005 14:11
Reporter: Charlie Ash Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:1.0.4 OS:Windows (Windows 2003)
Assigned to: Assigned Account CPU Architecture:Any

[15 Aug 2005 3:45] Charlie Ash 
Description:
If you declare a stored procedure with new line characters between parameters, the driver give an error like "Parameter ? must be declared".

How to repeat:
call the following stored procedure:

CREATE PROCEDURE Test(IN p1 int,
IN p2 int,
IN p3 int)

< any query >

Suggested fix:
StoredProcedure.cs line 91

string[] parts = Utility.ContextSplit( paramDef.ToLower(), " \t", "");

Change to

string[] parts = Utility.ContextSplit( paramDef.Trim().ToLower(), " \t", "");
[15 Aug 2005 14:11] Reggie Burnett 
This has already been reported and fixed.