Convert OracleDbType.Decimal to C# decimal

[MartinKK]

Hi all,
I have a problem with converting OracleDbType.Decimal to System.Decimal. I
have the following code:
....(class)
public decimal speed;
OracleCommand cmd = new OracleCommand("GETNORM", dataCa.connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("return", OracleDbType.Int32).Direction =
ParameterDirection.ReturnValue;
cmd.Parameters.Add("CODE", OracleDbType.Decimal).Value = idSubject;
cmd.Parameters.Add("OUTSPEED", OracleDbType.Decimal).Direction =
ParameterDirection.Output;
cmd.ExecuteNonQuery();
this.speed = (Decimal)cmd.Parameters["OUTSPEEDVALUE"].Value;
....
The last line causes runtime error: Specified type-cast is invalid (I'm
translating from Czech language). In VS2008 debug I see, that
"cmd.Parameters["OUTSPEEDVALUE"].Value" has value (OUTSPEEDVALUE = 62).
My question is: How can I assign value from Oracle parameter to .NET (C#)
variable.
I'm unhappy 2 days.
Thanks
Martin

 

[Armin Zingler]

Hi all,
I have a problem with converting OracleDbType.Decimal to System.Decimal. I
have the following code:
....(class)
public decimal speed;
OracleCommand cmd = new OracleCommand("GETNORM", dataCa.connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("return", OracleDbType.Int32).Direction =
ParameterDirection.ReturnValue;
cmd.Parameters.Add("CODE", OracleDbType.Decimal).Value = idSubject;
cmd.Parameters.Add("OUTSPEED", OracleDbType.Decimal).Direction =
ParameterDirection.Output;
cmd.ExecuteNonQuery();
this.speed = (Decimal)cmd.Parameters["OUTSPEEDVALUE"].Value;
....
The last line causes runtime error: Specified type-cast is invalid (I'm
translating from Czech language). In VS2008 debug I see, that
"cmd.Parameters["OUTSPEEDVALUE"].Value" has value (OUTSPEEDVALUE = 62).
My question is: How can I assign value from Oracle parameter to .NET (C#)
variable.
I'm unhappy 2 days.
Thanks
Martin

What's the data type of cmd.Parameters["OUTSPEEDVALUE"].Value? (quick
watch or assign to Object variable) I don't see a special OracleDecimal
data type inside the System.Data.OracleClient namespace. Only
OracleNumber, but there, conversion to Decimal is defined and should
work then.


Armin

 

[MartinKK]

Hi all,
I have a problem with converting OracleDbType.Decimal to System.Decimal. I
have the following code:
....(class)
public decimal speed;
OracleCommand cmd = new OracleCommand("GETNORM", dataCa.connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("return", OracleDbType.Int32).Direction =
ParameterDirection.ReturnValue;
cmd.Parameters.Add("CODE", OracleDbType.Decimal).Value = idSubject;
cmd.Parameters.Add("OUTSPEED", OracleDbType.Decimal).Direction =
ParameterDirection.Output;
cmd.ExecuteNonQuery();
this.speed = (Decimal)cmd.Parameters["OUTSPEEDVALUE"].Value;
....
The last line causes runtime error: Specified type-cast is invalid (I'm
translating from Czech language). In VS2008 debug I see, that
"cmd.Parameters["OUTSPEEDVALUE"].Value" has value (OUTSPEEDVALUE = 62).
My question is: How can I assign value from Oracle parameter to .NET (C#)
variable.
I'm unhappy 2 days.
Thanks
Martin

What's the data type of cmd.Parameters["OUTSPEEDVALUE"].Value? (quick
watch or assign to Object variable) I don't see a special OracleDecimal
data type inside the System.Data.OracleClient namespace. Only
OracleNumber, but there, conversion to Decimal is defined and should
work then.


Armin

Hi,
I'm sorry, there is error. Right is:
cmd.Parameters.Add("OUTSPEEDVALUE", OracleDbType.Decimal).Direction =
ParameterDirection.Output;
Martin

 

[Armin Zingler]

What's the data type of cmd.Parameters["OUTSPEEDVALUE"].Value? (quick
watch or assign to Object variable) I don't see a special OracleDecimal
data type inside the System.Data.OracleClient namespace. Only
OracleNumber, but there, conversion to Decimal is defined and should
work then.

Hi,
I'm sorry, there is error. Right is:
cmd.Parameters.Add("OUTSPEEDVALUE", OracleDbType.Decimal).Direction =
ParameterDirection.Output;
Martin

Yes, but it doesn't answer my question.

Armin

 

[datavalue]

Have you tried this.speed = (Decimal)(OracleDecimal)cmd.Parameters["OUTSPEEDVALUE"].Value;

The first () calls a type conversion to OracleDecimal then the second converts to Decimal.

There is also the Convert.ToDecimal(cmd.Parameters["OUTSPEEDVALUE"].Value) which will skip the double type conversion.

Give them a try.