CIII. Oracle Functions (PDO_OCI)

Введение

Внимание

Это расширение является ЭКСПЕРИМЕНТАЛЬНЫМ. Поведение этого расширения, включая имена его функций и относящуюся к нему документацию, может измениться в последующих версиях PHP без уведомления. Используйте это расширение на свой страх и риск.

PDO_OCI is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to Oracle databases through the OCI library.

Содержание
PDO_OCI DSN -- Connecting to Oracle databases

Oracle Functions (PDO_OCI)

moc.aciremi@yvelj
01-Jun-2006 12:25


A Statement of Warning:



PDO::oci does not support REF CURSORS.



This is mentioned nowhere (until now!) on this page. 



And now you know!



If you want ref cursors avoid PDO for now. 



My Reference for this claim:

http://www.oracle.com/technology/pub/articles/

php_experts/otn_pdo_oracle5.html



GREAT article, excellent piece, really. It's not clear to me 

how old this document is, but it must have some dust on it, 

given it's references to "PHP5.1 ...' which is a little way off yet' "

... as of 2006-06-01, PHP5.1 has been with us for quite some time.

cursade at hotmail dot com
20-Apr-2006 11:29


if oracle and oracle instant client has been installed,

without db in the same host



For UNIX/LINUX，set $LD_LIBRARY_PATH

appent your instant client path  and  client/lib path to it,



For windows set PATH like this



After set the path ,set TNS_ADMIN everioment ,point to 

where  tnsnames.ora located.



Then,you can use service name to connect to your Database



Test coding



<?php

$param = $_POST;

$db_username = "youusername";

$db_password = "yourpassword";

$db = "oci:dbname=yoursid";

$conn = new PDO($db,$db_username,$db_password);

$name = $param['module'];

$file = $param['file'];

$stmt = $conn->exec("INSERT INTO AL_MODULE (AL_MODULENAME, AL_MODULEFILE) VALUES ('$name', '$file')");



?>

cursade at hotmail dot com
20-Apr-2006 02:43


If instant client has been installed but the full oracle client

not yet ,you can use pdo to connect to oracle database

like following coding:



<?php

$tns = "  

(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = yourip)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

       ";

$db_username = "youname";

$db_password = "yourpassword";

try{

    $conn = new PDO("oci:dbname=".$tns,$db_username,$db_password);

}catch(PDOException $e){

    echo ($e->getMessage());

}

?>