Output parameter not returned from stored Proc

Question

I call SQL-proc which has 3 OUTPUT parameters. After calling proc, one of the parameters does not return a value when the other two do. The profiler shows that all 3 values ​​are returned.

Parameters are declared as follows in proc ...

@UsrVariableID INT OUTPUT,
@OrganisationName NVARCHAR(256) OUTPUT,
@Visible bit OUTPUT

and the code that calls proc looks like this:

cm.Parameters.AddWithValue("@OrganisationName", name);
cm.Parameters["@OrganisationName"].Direction = ParameterDirection.Output;
cm.Parameters.AddWithValue("@Visible", visible);
cm.Parameters["@Visible"].Direction = ParameterDirection.Output;

cm.ExecuteNonQuery();

name = cm.Parameters["@OrganisationName"].Value.ToString();
visible = bool.Parse(cm.Parameters["@Visible"].Value.ToString());
id = int.Parse(cm.Parameters["@UsrVariableID"].Value.ToString());

The parameter that fails is @OrganisationName.

I am wondering if this is because the parameter has a type string in the code, but NVARCHAR in proc.

Does anyone have any ideas?

Answer 1

, (nvarchar, varchar ..), , . , , #. , , , :

SqlParameter theOrganizationNameParam = new SqlParameter( "@OrganisationName", SqlDbType.NVarChar, 256 );
theOrganizationNameParam.Direction = ParameterDirection.Output;
cm.Parameters.Add( theOrganizationNameParam );
cm.ExecuteNonQuery();
name = theOrganizationNameParam.Value;

, , , .

, .

Answer 2

( ) , .

cm.Parameters.Add["@OrganisationName", SqlDbType.NVarChar, 256].Direction = ParameterDirection.Output
cm.Parameters["@OrganisationName"].Value = name

, - , .

, .Parse(.ToString()), .

visible = bool.Parse(cm.Parameters["@Visible"].Value.ToString());

visible = (bool)cm.Parameters["@Visible"].Value;

Answer 3

100% MS SQL, .NET → Oracle .

cm.Parameters["@OrganisationName"].Size = 256;

Answer 4

, , , . , .

Answer 5

ParameterDirection.InputOutput -

- http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic28087.aspx

Answer 6

, .

.

cm.Parameters["@OrganisationName"].Size = 50;

- , , .

, nvarchar (max). SELECT, .

Answer 7

, , , : .

, nvarchar (7), #.NET = 255, , 7 ....

, ... ...