Oracle connection

[Anon]

Hi,

I am running a PHP script on unix. I am trying to connect to Oracle database.
Before i start using the functions like Ora_Logon etc, what steps do i have to take in order to make PHP talk to Oracle database?
Your help is greatly appreciated.

Thanks,
snm

[Anon]

First off, I would start with using the OCI8 functions istead of the Ora() functions. The Ora functions are older and offer less functionality. The OCI8 section (http://www.php.net/manual/en/ref.oci8.php) of the PHP Manual will gives a number of examples.

-- Michael
Darkstreak Consulting
www.darkstreak.com

[nikhilji]

If you do decide to use the Oracle 7 functions, your code should look like:

putenv("ORACLE_SID=[Your SID]");
putenv("ORACLE_HOME=[Directory path for Oracle]");
$user = "user/pass@tableslace";
$conn = ora_logon($user,"");
$curs = ora_open($conn);
ora_commitoff($conn);

that's what i have done in the past.