php/oracle

[Anon]

Can any 1 tell me whats the diff between ora built in functions and the OCI fucntions.

And if possible can some 1 pls send me a sample script of connection to oracle d/b and firing a query.
Multiple results.

And pls tell me which 1 is better to use for me ..i have an oracle 8.1.7 d/b version
thanx in advance

[Anon]

OCI is Oracle 8, on my system the ora functions don't work with Oracle 8.

Here comes an OCI query function example. You will need $dbuser, $dbpwd variables that contain your access data.

function db_query($sql)
{
global $dbuser, $dbpwd;
$conn = ocilogon($dbuser, $dbpwd);
if (!$conn)
die ("DB error");

    $stmt = ociparse($conn, $sql);
    ociexecute($stmt);
    $zeilen = array();
    $result = array();

    $i=0;

    while(OCIFetchInto($stmt, &$result, OCI_NUM))
    {
            $zeilen[$i] = $result;
            $result = array();
            $i++;
    }

    ocilogoff($conn);

    return $zeilen;

}

Note that I experienced zombies being produced by the Apache Web Server in combination with PHP4 and Linux. It's Apache's fault, we tried around a bit changing versions, now it works.

[Anon]

It still doesn't work

Ihave the php_oci8.dll file

error message:
Fatal error: Call to undefined function: ocilogon() in c:\oracle\ora81\apache\apache\htdocs/test.html on line 4

thanx

[Anon]

It worked..but problem is
When the page comes up it gives a huge php.exe error......mem allocation....etc etc
but the d/b connection works fine
is it the problem of the dll that i have?
Can u pls send me the oci8.dll that u have so that i can verify it.....
thanx