ExecuteScalar method of OracleCommand object

[CraigBest]

Hope someone can answer this for me...

I'm using the Oracle Data Provider to access data from an Oracle Database in a VB.NET program I'm writing. I'm using the data provider successfully to return datasets, but I wanted to use a method of the OracleCommand object called ExecuteScalar to return single-field values from the DB. However, when I use it I'm not getting back the string (text) values I espect, I'm getting back decimal values instead.

Have I made a mistake? Does this method only return decimal values? Is there a better method for me to get back single text values from the DB that I should try?

Help please! Thank you.

CraigHartz

 

[RhythmAddict112]

You should be able to return a string without issue. I think you will have much more luck if you a) post your code (vb.net and b) post this in the VB.NET forum instead...Assuming that your oracle stored proc. works as intended in SQL*Plus..HTH.

http://geekswithblogs.net/sanjayu/

 

[CraigBest]

Hi Rhythm,

Yes, you are right -- I traced the problem to trying to stuff the returned value into an object and not a string variable. When I made that change it worked properly. Thanks!

 

[RhythmAddict112]

NP - cheers!

http://geekswithblogs.net/sanjayu/