Oracle Clob to C# String

Question

I am using the Oracle.ManagedDataAccess.Client to get data from Oracle into C#. My return value I am retrieving is a Clob:

 cmd.Parameters.Add("return_value", OracleDbType.Clob).Direction =
   ParameterDirection.ReturnValue;

I cannot seem to convert this into a string or anything C# recognises.

How are you trying though? Clobs are streams so you'll probably be looking at something like var s = new StreamReader(parameter.Value).ReadToEnd() — Caius Jard
– Caius Jard, Commented Aug 3, 2020 at 8:48
I am doing, string test = cmd.Parameters["return_value"].Value.ToString(); but it isn't working. I tried new StreamReader(cmd.Parameters["return_value"].Value.).ReadToEnd(), but it is saying it cannot convert from object to System.IO.Stream — Vernon007
– Vernon007, Commented Aug 3, 2020 at 9:08

Vernon007 · Accepted Answer · 2020-08-04 06:46:07Z

2

I managed to do it with this:

OracleClob myLob = (OracleClob)cmd.Parameters[0].Value;
                    ret_string = Convert.ToString(myCLob.Value);

answered Aug 4, 2020 at 6:46

Vernon007

2102 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HugoHiasl · Accepted Answer · 2020-08-03 09:58:04Z

0

Did you try something like (where clob is your Clob)?

string clobValue = (string) clob.Value;

According to this solution it should work: Converting a large CLOB object to .NET string to put into a DataGridView cell

answered Aug 3, 2020 at 9:58

HugoHiasl

3343 silver badges16 bronze badges

1 Comment

Vernon007 Over a year ago

When I do that, I get Oracle.ManagedDataAccess.Types.OracleClob. When I debug, I can go to cmd and then parameters, and then return_value, the value property has 'Oracle.ManagedDataAccess.Types.OracleClob', but when I expand Value, it has another value property with the string I want.

Saharat Sittipanya · Accepted Answer · 2024-05-07 04:01:53Z

0

I use this

string clob_str = ((OracleClob)Command.Parameters["return_value"].Value).Value;

answered May 7, 2024 at 4:01

Saharat Sittipanya

3312 silver badges7 bronze badges

Collectives™ on Stack Overflow

Oracle Clob to C# String

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related