Pear:DB works w/ mysql but not oci8???

[gurubob]

Hi,

I have been searching for an answer to this one but have not found too much. Allan Kent has a great article on here about using PEAR's DB support (see URL below). I have the following code:

<?
require_once( 'DB.php' );
echo "Connect to Oracle Database...";
$db = DB::connect("oci8://user:pass@host/databasename");
$sql = 'SELECT * FROM table';
$demoResult = $db->query($sql);
while ($demoRow = $demoResult->fetchRow()) {
echo $demoRow[2] . '<br>';
}
$db->disconnect();
?>

It works fine for a mysql:// DB::connect but the oci8:// (as above) tells me:

Fatal error: Call to undefined function: query() in c:\htdocs\oracletest.php on line 6.

Any ideas here?

http://www.phpbuilder.com/columns/allan20010115.php3?print_mode=1

Cheers,

• Bob -

[Anon]

You need to check to make sure the connection was successful... I think it's

if(DB::isError($db)) {
// you have an error
}
else {
// do all your work
}

or something like that...

[gurubob]

Thanks for the tip - have been digging more since my original post.

The problem is that I don't have the oci8 functionality enabled - and enabling it opens another can of worms (ie, making sure that client dll's are present etc). Still have to resolve that.

Pear😃B will not report "Undeclared function" if the support for oci8 is not actually present.

Cheers,

• Bob -