C# Oracle CLOB

[Puleen Patel]

I am not sure if anyone has a quick and proofed solution for this.
Using C# I am trying to insert a new record into oracle database, where two
of the fields are
CLOB's. I am using Parameterized queries and running into a problem when
trying to add
one of the parameters to the command object. The error I get is as follows:

Parameter 'text_search': No size set for variable length data type: String.

text_search is a CLOB field.

To add to the parameters I am doing the following:

oCommand.Parameters.Add("text_search",this.text_search);

Anyone suggest a good way to use parameterized queries and to add records to
Oracle using C#?

puleen at canada dot com
Cheers

 

[Paul Clement]

On Mon, 22 Mar 2004 14:19:07 -0500, "Puleen Patel" <puleen at canada dot com> wrote:

¤ I am not sure if anyone has a quick and proofed solution for this.
¤ Using C# I am trying to insert a new record into oracle database, where two
¤ of the fields are
¤ CLOB's. I am using Parameterized queries and running into a problem when
¤ trying to add
¤ one of the parameters to the command object. The error I get is as follows:
¤
¤ Parameter 'text_search': No size set for variable length data type: String.
¤
¤ text_search is a CLOB field.
¤
¤ To add to the parameters I am doing the following:
¤
¤ oCommand.Parameters.Add("text_search",this.text_search);
¤
¤ Anyone suggest a good way to use parameterized queries and to add records to
¤ Oracle using C#?
¤

Are you using Microsoft's .NET Provider or Oracle or Oracle's ODP.NET?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Puleen Patel]

Microsoft's .NET provider is what I am using.

 

[Paul Clement]

On Mon, 22 Mar 2004 14:52:05 -0500, "Puleen Patel" <puleen at canada dot com> wrote:

¤ Microsoft's .NET provider is what I am using.
¤

See if the following thread helps:

http://www.dotnet247.com/247reference/msgs/20/103072.aspx


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Puleen Patel]

I looked at that link you pasted, unfortunately I am still getting the same
error:

Parameter 'text_search': No size set for variable length data type: String.

where text_search is a CLOB field, I have another CLOB field as well

 

[Paul Clement]

On Tue, 23 Mar 2004 16:25:19 -0500, "Puleen Patel" <puleen at canada dot com> wrote:

¤ I looked at that link you pasted, unfortunately I am still getting the same
¤ error:
¤
¤ Parameter 'text_search': No size set for variable length data type: String.
¤
¤ where text_search is a CLOB field, I have another CLOB field as well
¤

Perhaps you could post the code you now have and identify on what line the error is occurring.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Puleen Patel]

I am rethinking the logic and retrying the whole insert process. Once I have
changed it, if I run into another related
problem I will post more with regards to the code that I am using.

Cheers

Puleen