Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

set .clob via ado.net

Status
Not open for further replies.
TravisLaborde

TravisLaborde

IS-IT--Management
Nov 4, 2002
84
US
I'm trying to insert data into an Oracle 8 database from ADO.NET 1.1, into a CLOB field.

If I just concatenate a big SQL string and push it in via .CommandText it works, as long as the CLOB data isn't over 4k (or close to that).

So, I've tried various methods to put that data in there, and have had no luck.

I was told that in the "old days" they did this with .AppendChunk which isn't availalbe in .NET anymore. The "new" way is to get the row, and use the data adapter to push it back in. Supposedly easy, but not working for me.

I'm using OleDB, Oracle 8 and .NET 1.1

Can anyone give me some example code that works? I just want to enter text based data over 4k :)

Thanks,
Travis
 
Status
Not open for further replies.

Similar threads

EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
531
carp
carp
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
177
fredericofonseca
fredericofonseca
kernal
  • Locked
  • Question
Is there any way to write a select statement for distinct when there is a CLOB field? 2
Replies
4
Views
271
john parker
john parker
AlStl
  • Locked
  • Question
Update via a VIEW or Direct Update
Replies
3
Views
109
Beilstwh
Beilstwh
yorge
  • Locked
  • Question
Return unique row from a given set of rows 2
Replies
3
Views
120
cmmrfrds
cmmrfrds

Part and Inventory Search

Sponsor

Back
Top