hi all,
I use to get an error while retrieving data from oracle databse.

Warning: ociparse(): supplied argument is not a valid OCI8-Connection resource in
Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in
Warning: ocirowcount(): supplied argument is not a valid OCI8-Statement resource in
Warning: ocifetch (): supplied argument is not a valid OCI8-Statement resource in

In the mean time I’m not getting any error but its not retrieving the data.

Part of my script:

<?php
$iDBConn = ocilogon("tiger", "scott", "oracldb"); $qGetEmployees = "SELECT STAFF_ENNAME FROM HR_STAFF_MAST";

$iStatement = @OCIParse($iDBConn, $qGetEmployees);
@OCIExecute($iStatement, OCI_DEFAULT);
// check our query

$arrError = OCIError($iStatement);
if ($arrError['code'])
{
print $arrError['message'];
exit;
}
while (OCIFetch($iStatement) ) {
echo"<tr>";
if(!empty($iStatement))
{
$result=OCIResult($iStatement, "STAFF_ENNAME");{
?>

I also tried $iDBConn = oci_connect("tiger", "scott", "oracldb");

but, i'm getting the following error
Fatal error: Call to undefined function: oci_connect()

please advice
hass_1979
Please help
thanks