ExecuteScalar(); with Oracle

[WynneSMI]

I'm having an issue with getting the result from and ExecuteScalar with an Oracle Db. No matter what type (int, long, etc.) I tell it to return, it always throws an exception. I have tried this:

int count = (int) SQLCommand.ExecuteScalar();

Along with many other options but nothing seems to work. The query runs fine if I run it directly against the Db. I'm use to using a SQL Server Db and don't have much experience with Oracle back-end Db. Does anyone know what is going on here?!?! Thanks.

 

[JohnEfford]

There are two command objects an SQL and OLEDB, the sql command object is specifically optimized for use with Microsoft SQL server. For any other server you will need to use an OleDBCommand.

Neither of the command objects mentioned have a stative method ExecuteScaler so you will have to icreate an instance variable as shown below

OleDbConnection OracleCn = new OleDbConnection("Your connection string, to Oracle Db");  

OleDbCommand = new OleDbCommand("Your command text",OracleCn);

Cheers