Peculiar Behavior In Stored Procedure (outputs Are Returning Proper Vals For Uniqueidentifiers And Ints, Not Nvarchars)

Rather than the real code, here's a sample we came up with.

 

Here's the C# Code:

public class sptest : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Label Label1;

private DataSet dtsData;



private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here

string strSP = "sp_testOutput";

SqlParameter[] Params = new SqlParameter[2];

Params[0] = new SqlParameter("@Input", "Pudding");

Params[1] = new SqlParameter("@Error_Text", "");

Params[1].Direction = ParameterDirection.Output;

try

{

this.dtsData = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["SIM_DSN"], CommandType.StoredProcedure, strSP, Params);

Label1.Text = Params[0].Value.ToString() + "--Returned Val is" + Params[1].Value.ToString();

}

//catch (System.Data.SqlClient.SqlException ex)

catch (Exception ex)

{

Label1.Text = ex.ToString();



}

}

 

Here is the stored procedure:

 

CREATE PROCEDURE [user1122500].[sp_testOutput](@Input nvarchar(76),@Error_Text nvarchar(10) OUTPUT)AS

SET @Error_Text = 'Test'GO

When I run this, it prints up the input variable, but not the output variable.