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

[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

 

[Frans Bouma [C# MVP]]

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...

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.