How to insert/retrieve CLOB values from/to Oracle9i using ODP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody

Is there anybody out there who could point me in the right direction in how to store and retrieve CLOB-values to/from an Oracle9i table. The data to be stored/retrieved are XML-documents from/to the local filesystem..

Thanks!!!
/Peter
 
Peter said:
Hi everybody!

Is there anybody out there who could point me in the right direction in how
to store and retrieve CLOB-values to/from an Oracle9i table. The data to be
stored/retrieved are XML-documents from/to the local filesystem...
Click to expand...

Retrieve them with normal select statements and a datareader or a
data-adapter and bind a REF CURSOR to a dataset. you can also return an
output parameter (but I'm not sure CLOB's are supported as output parameters)

Insert them by passing an OracleParameter and set its value to the actual
textstring.

Seems pretty normal stuff, so I'm not sure where the problems are :) Perhaps
you can paste some code?

Frans.
 
Back
Top