conn to Oracle, just getting started

Anon

I think my problem here is that I have an incorrect path to Oracle or that somehow it can't navigate using this path from where I am, but I though I would ask to see if anyone notices any syntax errors.

My code (at bottom of message) was copy/pasted from a tutorial at phpworld. I'll just give you a snippet because it doesn't get past the second command.

My error is:
Fatal error: Call to unsupported or undefined function ora_login()

I'm guessing that ora_login() is undefined because it can't find oracle from my faulty path. What do you think? Any other ideas?

*************** CODE *****************

<?php

PutEnv("ORACLE_SID=/u01/app/oracle/product/8.1.5");

$connection = Ora_Logon ("username", "password");
if ($connection == false){
echo Ora_ErrorCode($connection).": ".Ora_Error($connection)."<BR>";
exit;
}

Anon

As you can see, I tried both Ora_Login() and Ora_Logon(), and neither worked.

kwidholm

What strikes me immediately is that you are calling your Oracle functions with upper case letters. According to documentation, it should be ora_plogon, and ora_errorcode, and ora_error ... etc.

See if that changes anything for you.

Anon

I've only recently seen a few references on php.net connecting to a remote oracle server rather than a local oracle server.

With out going into why you would do this, which is obvious if you have ever worked with Oracle before - HOW do you actually do a remote connection?

John

zibworm wrote:

As you can see, I tried both Ora_Login() and Ora_Logon(), and neither worked.

Anon

I experienced the same problem until I discovered that ocilogon() worked (while ora_logon() didn't). Note that ocilogon() exists from PHP V 3.0.8.

Perhaps this works with your environment, too.

Anon

If you hadn't already figured it out - you need to enable Oracle as a module, by removing the commenting in php.ini (or whatever is required for your platform...)

look for "oracle" in php.ini, and all should become clear !

Nev

Anon

I have the same problem - on a Linux system - I'm trying to
connect to Oracle on another system - my system does
not have oracle on it. I was told to download the L&G
PHP and configure with --ora_something.
The configure script now says it can't fine the ora libs.

Where do I get them?

Tks

pedershk

that's because you have to install the Oracle 8.17 client files on your machine, and specifically the Net8 client.

You also need to set up name resolution, i.e. tnsnames.ora. If you don't know what I'm talking about, you should talk to your local Oracle admin.

Regards,
Henning Pedersen