using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;
using System.Data;
namespace ConsoleApplication11
{
class Program
{
static void Main(string[] args)
{
try
{
string oradb = "User Id=tester;" +
"Password=tester; " +
@"Data Source=(DESCRIPTION=(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.221)(PORT=1521)))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))";
Environment.SetEnvironmentVariable("PATH", Environment.CurrentDirectory + "\\ODP\\", EnvironmentVariableTarget.Process);
using (OracleConnection conn = new OracleConnection(oradb))
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = @"SELECT '데이타' FROM DUAL";
cmd.CommandType = CommandType.Text;
using (OracleDataReader dr = cmd.ExecuteReader())
{
dr.Read();
string txt = dr.GetString(0);
Console.WriteLine(txt);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.ToString());
Console.ReadLine();
}
Console.ReadLine();
}
}
}