On 04/12/2006 11:25:50 AM, Simone Saravalli wrote: > hi to everybody, > I use Oracle 10g Express and I'm dealing with the connection to the > database in php through the use of pear. In order to connect to the > database I use the function DB::connect() provided by the pear > package, but google told me that the connection is allowed only up to > oracle version 9. With the oci_connect() function always goes right, > so I suspect there's something wrong in pear. Someone else has the > same experience? > > Thanks in advance, Simone Saravalli
PEAR::DB is a little bit outdated and a little bit slow, but other then that, there is nothing wrong with it. It can connect to Oracle 10G, both R1 & R2 because it uses the underlying OCI8 driver, which can connect to Oracle 10g. The only quirk is that with 10.2, the protection of some directories ($ORACLE_HOME/lib, $ORACLE_HOME/network/admin, $ORACLE_HOME/nls) are wrong and needs to be fixed. Fortunately, the latest patchset contains script $ORACLE_HOME/install /changePerm.sh which will fix the protection bits. My advice nevertheless is to use ADOdb instead. It is faster, it supports exceptions, it is extremely convenient and it is well maintained, with newer releases appearing much more frequently then with PEAR: :DB. ADOdb can be found at http://adodb.sourceforge.net
Here is a little PHP script used for testing: #!/usr/local/bin/php
<?php require_once('DB.php'); $DSN="oci8://scott:tiger@(protected)"; $db=DB::connect($DSN); if (DB::iserror($db)) { die($db->getUserInfo()); } $db->autoCommit(FALSE); $sql="select * from dept"; $sth=$db->query($sql); if (DB::iserror($sth)) { die($sth->getUserInfo()); } $cols=$db->tableInfo($sth); echo "This result has ",count($cols)," columns\n";
foreach ($cols as &$col) { echo $col['name'],"\t"; } echo "\n"; while ($sth->fetchinto($row)) { foreach ($row as &$val) { print "$val\t"; } echo "\n"; } $tst=$db->prepare("delete from non_existing_table"); if (DB::isError($tst)) { die($tst->getDebugInfo()); } print "Kilroy was here!\n"; $tst1=$db->execute($tst); if (DB::isError($tst1)) { die($tst1->getDebugInfo()); }
?>
The output of the script is:
$ ./simone.php
This result has 3 columns DEPTNO DNAME LOC 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON Kilroy was here! delete from non_existing_table [nativecode=ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist]
The "Kilroy" part was inserted for me to see when will the latest PEAR perform parse operation. As it turns out, it does deferred parse, bundled with the "execute", as expected. This is what I have:
