static void Main(string[] args)
{
//setUpVariables();
DBAccessController obj = new DBAccessController();
if (DBAccessController.dbGetOracleConnection() != null)
{
DataTable ddt = createOraCmd();
if (ddt != null)
{
createFileFromDt(ddt);
}
}
else
{
Main(null);
}
}
static DataTable createOraCmd()
{
DataTable dt = null;
try
{
WriteLine("Command Line = ");
cmd = ReadLine();
OracleCommand oraCmd = new OracleCommand(cmd, DBAccessController.dbGetOracleConnection(connection));
OracleDataAdapter da = new OracleDataAdapter(oraCmd);
da.Fill(dt);
return(dt);
}
catch
{
dt = null;
}
return(dt);
}