Oracle9i - PHP 4.2.0 - Win2000 - blank page
| From: | mh | Date: | Thu, 09 May 2002 00:43:40 +0000 |
| Subject: | Oracle9i - PHP 4.2.0 - Win2000 - blank page | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-6918@lists.php.net to get a copy of this message | ||
I having trouble connecting to Oracle9i:
PHP 4.2.0
Oracle9i 9.0.3.1
Windows 2000 Professional
Apache 1.3.24
Checked with a php page <?php phpinfo();?>, php_oci8.dll is loaded.
Tnsnames.ora configured
properly also.
This is the source I am using:
<?php
putenv("ORACLE_HOME=D:\oracle\ora90");
putenv("TNS_ADMIN=D:\oracle\ora90\network\admin\tnsnames.ora");
putenv("ORACLE_SID=orcl");
$connection = OCILogon('scott', 'tiger', 'orcl');
if ($connection == false){
echo OCIError($connection)."<BR>ERROR";
exit;
}
$cursor = OCIParse ($connection, "select ename from scott.emp");
@OCIExecute ($cursor, OCI_DEFAULT);
while (OCIFetchInto ($cursor, $values))
{
echo $values[0];
echo"<br>";
}
?>
Any ideas?