OracleCommadbuilder: Exception: Parameter 'p1': No size set for variable length data type: String.

P

Peter Meinl

When updating an Oracle Varchar2 column with an empty string "" using the
OracleCommandBuilder generated UpdateCommand the follwing error is thrown:
"Parameter 'p1': No size set for variable length data type: String."

Is this a bug in the OracleCommandBuilder? Is there an elegant workaround?

Updating with DBNull.Value instead of an empty string does not throw the
above error.
 
G

Guest

Hello,

I am re-raising this post as we have a developer here running into the same issue. Is this a bug or a feature? Are there any similar bugs or features of other datatypes that we should be aware of?

Thanks!
 
R

Ryszard Gawron [MS]

Hello,
yes, this is a bug in the current version of Visual Studio .net and should
be fixed in the next one.

Best regards

Ryszard Gawron
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

ASP.NET said:
Hello,

I am re-raising this post as we have a developer here running into the
Click to expand...
same issue. Is this a bug or a feature? Are there any similar bugs or
features of other datatypes that we should be aware of?
 
P

Peter Meinl

As a workaround it is OK to send DBNull.Value instead of an empty string.
Oracle transforms emtpy strings to Null anyway.
 
S

SqlJunkies User

I have .NET Framework 1.1 SP1 (just recently released) installed and still get this message. Worse, when I try to use ODP (directly from Oracle), I am getting a "Concurrency violation: the UpdateCommand affected 0 records." In this situation. Can anyone shed light on this strange error?
 
S

Sushil Chordia

Can you send a code-snippet that will help us solve the problem?
--
HTH,
Sushil Chordia.
This posting is provided "AS IS" with no warranties, and confers no rights.
SqlJunkies User said:
I have .NET Framework 1.1 SP1 (just recently released) installed and still
Click to expand...
get this message. Worse, when I try to use ODP (directly from Oracle), I am
getting a "Concurrency violation: the UpdateCommand affected 0 records." In
this situation. Can anyone shed light on this strange error?supports Post Alerts, Ratings, and Searching.
 

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

"No size set for variable length data" Oracle update error with empty string in .NET 1
No size set for variable length data type : OracleCommandBuilder 2
No size set for variable length data type: String 0
Probem: No size set for variable length data type: String, using OracleDataAdapter 4
Re: Parameter size for NVARCHAR(MAX) data type? 0
sql server return parameter size. 5
URGENT: Oracle: String buffer too small 2
Parameter size for NVARCHAR(MAX) data type? 1

Top