How do i set connection to oracle db to get data from Dual?

Nepethya Rana

I would like to get temporary data so i created this query SELECT 'BMW' as Car, 'Peter' as Owner FROM DUAL UNION ALL SELECT 'Mustang' as Car, 'Joe' as Owner FROM DUAL;

I do not know how to set connection to the Data base to execute this query in DB from my program.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nepethya Rana9y ago
I figured out, I forgot to pass connection string in command obj. Thank you for reaching and helping out.
Nepethya Rana9y ago
CS :
class Program{
static string myCS = ConfigurationManager.ConnectionStrings["MYCS_ORA"].ConnectionString;
static void Main(string[] args)
{
SomeMethod();
}
Public static void SomeMethod(){
OleDbConnection ora_conn = new OleDbConnection();
OleDbCommand ora_cmd = new OleDbCommand();
OleDbDataReader ora_reader = null;
try
{
ora_conn = new OleDbConnection(myCS );

ora_conn.Open();

if (ConfigurationManager.AppSettings["Test_Environment"].ToUpper() == "TRUE")
{

ora_cmd = new OleDbCommand(ConfigurationManager.AppSettings["Test_VW_Table_Query"]);

}
else
{
ora_cmd = new OleDbCommand("SELECT Car, Owner FROM Real_VW_Table", ora_conn);

}

ora_reader = ora_cmd.ExecuteReader();

}
catch (Exception e)
{

WriteToLog(e.StackTrace);

}
}
}
Error:
3/27/2017 9:06:29 AM: System.InvalidOperationException: ExecuteReader: Connection property has not been initialized.
at System.Data.OleDb.OleDbCommand.ValidateConnection(String method)
at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String method)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at Program.SomeMethod()
Ramesh Palanivel9y ago
Are u using ASP MVC application
Nepethya Rana9y ago
My situation is data is not in view table but for the program to run and test i need data. I do not have access to insert test data on view table also. So i am trying to get these data from dual and pass them to my program to get into next step. If there is alternate way to do this. I have never worked with Oracle also.
Ramesh Palanivel9y ago
Hi Gaurav, Which means kindly send Ur error code.. I will help u...
Ramesh Palanivel9y ago
Hi Gaurav, Can u share Ur code....
Nepethya Rana9y ago
I am getting error.
Ramesh Palanivel9y ago
Hi Gaurav,

Your question is not clear. DO you want to fetch this record from Oracle DB or You are getting any error for this query?

Or Do you want get connection for your oracle DB?