PHP OCI8 functions giving problems with Oracle 7 DB

sellers

I use the following code snippet using OCI8 functions to retieve details from an Oracle 9 database, but when I run it against an Oracle 7 database I get a Warning: ocifetchstatement(): OCIFetchStatement: ORA-01002: fetch out of sequence message - I seem only to be getting back column names - the columns themselves appear empty.

I know OCI8 functions are supposed to work with Oracle 7.

$conn = OCILogon($user, $password, $db) 
    or die(var_dump( OCIError()));
$stat = OCIParse($conn, "select * from general_codes") 
    or die(var_dump( OCIError()));
OCIExecute($stat, OCI_DEFAULT) 
    or die(var_dump( OCIError()));

//GET THE COLUMN NAMES
$titles = array();
$cols = OCINumCols($stat);
for ($c = 1; $c <= $cols; $c++)
    $titles[] = OCIColumnName($stat, $c);

//GET THE COLUMN VALUES
$contents = array();
OCIFetchStatement($stat, $contents);

Any ideas would be greatly appreciated?

TTT

You will need the Oracle8 client libraries to use this extension. Windows users will need at least Oracle version 8.1 to use the php_oci8.dll dll.

Before using this extension, make sure that you have set up your Oracle environment variables properly for the Oracle user, as well as your web daemon user.

sellers

The Oracle 9 database is situated on the same machine as the webserver, PHP files and Oracle8 client libraries.

The Oracle 7 database is on a remote machine.

I'm not so familiar with oracle: I'd have thought that would be OK, no?

Might I have to alter settings for the remote web daemon aswell?

Thanks.

TTT

yes i think... :rolleyes:

sellers

Um, maybe you misunderstood me.

I have the correct client setup on the webserver.

It is the database (Oracle 7) only which is on a remote machine.

So far as I can see, the manual which you were quoting from only talks about the clientside.