Re: PHP/Oracle Command line Segmentation Fault
| From: | Christopher Ditty | Date: | Fri, 10 Jan 2003 14:29:56 +0000 |
| Subject: | Re: PHP/Oracle Command line Segmentation Fault | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-131111@lists.php.net to get a copy of this message | ||
Anyone?
CDitty
>>> "Christopher Ditty" <cditty@mlgw.org> 01/09/03 04:04PM >>>
I have successfully installed oracle 8.1.7 w/ php and have it
configured
to run from the command line. When I run a simple script that
connects,
and selects records from the database, the last line is a segmentation
fault error. This does not seem to happen when the same script is run
through the browser.
Can anyone offer any help or advice? The code is listed below.
CDitty
#!/usr/bin/php
<?
function oci8Connect(){
$db_conn = ocilogon("usrname","pwd", "dbase");
if (!$db_conn){
echo "Help<br>";
exit ();
}
echo "Connected<br>";
return ($db_conn);
}
$conn = oci8Connect();
$stmt = ociparse($conn,"select * from US_MSTR");
ociexecute($stmt);
$i=0;
$row = array();
while(OCIFetchInto($stmt, &$row, OCI_ASSOC)){
# do stuff with $row...
echo $row['US_ID'] . " $i<br>";
$i++;
}
ocifreestatement($stmt);
ocilogoff($conn);
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php