Posted by Keith E. Sauvant on 11/18/06 11:40

A behaviour we don't understand:

+++
$user = 'xxx';
$password = 'xxx';
$database = 'xxx.xxx';

$query = 'SELECT 1 FROM DUAL';
$link = OCIlogon($user, $password, $database);

//$parse = OCIParse($link, $query);
unset($link);

$link = OCIlogon($user, $password, $database);
$parse = OCIParse($link, $query);
+++
-> "... is not a valid oci8 connection resource"

Everything works fine if the first line with $parse is not
commented out. Everything also works fine if we do not
unset $link.

This behaviour occurs with ocilogon(), not with
either ociplogon() or ocinlogon().

Tested with PHP 4.3.11 on Linux, Apache 1.3.33 and Apache
1.3.34, OCI PECL extension 1.1.1, Oracle 10.2.01 and
10.1.0.3.

Best regards
Keith

• Next in forum: Re: A PHP/MySQL Connnector Problem
• Prev in forum: Re: Forced user logout / Cancel sessions and cleanup
• Thread view: Strange problem connecting php to oracle db

[Reply to this message]