ezoracle extension

Tuesday 06 December 2005 7:25:37 am

Hi Amer.

"i installed the ezoracle extension. Can anyone help in how to use it ? my goal is to display data in a page and these data should be retrieved from orcale db."

First, please read INSTALL file. It explains how to install the extension and make Exponential use Oracle.

"what are the benefits of using ezoracle extension instead of using PHP to connect and fetch data from oracle db."

Exponential does not use database directly. Instead, the interaction is done with ezdb library providing generic database access API. ezoracle contains a driver for ezdb that makes it possible to migrate an Exponential site to Oracle.
If your site is running on an other DBMS and you just need to execute a couple of Oracle queries, there's no need to use ezoracle.

Tuesday 06 December 2005 7:51:35 am

No, I think you don't need ezoracle much in this case.

Wednesday 07 December 2005 5:18:37 am

"ok, i won't use the ezoracle extension. Can i use ezDB class to connect to oracle DB ? if yes please could you explain how can i pass the parameters ?"

:-) Sure you can. But if you're using ezdb to connect to Oracle that implies using ezoracle as Oracle driver for ezdb.
Usage of ezdb over Oracle doesn't differ from using it over MySQL.
Please see the INSTALL file.

Wednesday 07 December 2005 7:19:39 am

"the idea is that i will still use the mysql connection as a master connection, and for a specific case i want to use the oracle driver to connect to the oracle database to retreive some data for display."
Yes, I understood.

"how can i configure ezdb to use the ezoracle extension to do so?
the installation guide shows how to use the oracle connection as a master database connection and not as an oxiliary connection. "

You must pass some extra parameters to eZDB::instance() in this case.
Example:

$parameters = array( 'server' => 'localhost',
                     'user' => 'scott',
                     'password' => 'tiger',
                     'database' => 'orcl' );
$db =& eZDB::instance( 'ezoracle', $parameters, true );

$result = $db->arrayQuery( 'SELECT * FROM tab' );
foreach ( $result as $row )
    echo $row['tname'] . "\n";