must set .Size property for output SQLParameter

  • Thread starter Thread starter John A Grandy
  • Start date Start date
J

John A Grandy

for ADO.NET SQLParameters with SQLParmaeter.Direction =
ParmeterDirection.Output ....

apparently , contrary to the documentation , you DO have to set the
SQLParameter.Size property ...

or you get errors like this :

Message "Parameter 1: '@EntityTypeName' of type: String, the property Size
has an invalid size: 0" String
 
I have found the same problem. Without the size it does not work. You need to
post the size of the output parameter or you will get the size error returned.

cheers
Hawk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SqlParameter.Size - When to use? 1
varchar(max) - SqlParameter 2
SqlParamater where type=SqlDbType.VarChar allows a size of -1!!! 2
sql server return parameter size. 5
SqlParameter is already contained by another SqlParameterCollectio 2
Dynamically Populating a SqlParameter object 5
Caching Parameters Performance Issue When Using SQLHELPER 2
Re: Parameter size for NVARCHAR(MAX) data type? 0

Back
Top