오라클 외부접속 채택완료

</p>

<p>define('G5_ORACLE_HOST', '아이피');

define('G5_ORACLE_USER', 'id');

define('G5_ORACLE_PASSWORD', 'password');

define('G5_ORACLE_DB', 'sid');</p>

<p> </p>

<p>$connect_db = sql_connect(G5_ORACLE_HOST, G5_ORACLE_USER, G5_ORACLE_PASSWORD) or die('ORACLE Connect Error!!!');</p>

<p> </p>

<p>function sql_connect($host, $user, $pass, $db=G5_ORACLE_DB)

{

    global $g5;</p>

<p>    $tns = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = $host)(PORT = 1521)))(CONNECT_DATA=(SID=$db)))" ;

    $conn = oci_connect($user, $pass, $tns, G5_DB_CHARSET) or die('ORACLE Connect Error!!!');</p>

<p>    if (!$conn) {

        $e = oci_error();

        die('Oracle Connect Error: ' . $e['message']);

    }</p>

<p>    return $conn;

}</p>

<p>