thanks miguel but i've already checked it, i've included return values
checking where it stop. Here's my full source test script.
There where no Ora_Error_Code returned.
<?
PutEnv("ORACLE_SID=PROD");
PutEnv("ORACLE_HOME=/u01/app/oracle/product/7.3.3_prod");
$connection = Ora_Logon("apps","apps");
if($connection==false){
echo Ora_ErrorCode($connection).":". Ora_Error($connection)."<BR>";
exit;
}
$cursor= Ora_Open($connection);
if($cursor==false){
echo Ora_ErrorCode($connection).":". Ora_Error($connection)."<BR>";
exit;
}
$query = "select * from mikecarel";
//$query = "select table_name from all_tables";
$result = Ora_Parse($cursor,$query);
if($result==false){
echo Ora_ErrorCode($connection).":". Ora_Error($connection)."<BR>";
exit;
}
$result=Ora_Exec($cursor);
if($result==false){
echo Ora_ErrorCode($connection).":". Ora_Error($connection)."<BR>";
exit;
}
echo"<table border=1>";
echo"<tr><td><b>Full Name</b></td><td><b>Email Address</b></td></tr>";
//$values=array(mike, tess);
while(Ora_Fetch_Into($cursor,$values)){
$name = $values[0];
$email = $values[1];
echo "<tr><td>$name</td><td>$email</td></tr>";
echo "$email";
print($name);
$result =1;
}
if(!$result==1) print("no result");
echo"</table>";
ora_close($cursor);
ora_logoff($connection);
?>
mike
> Check the return values from your ora_logon, ora_open, ora_parse, and
> ora_exec calls to see whether they worked. That way you can know at
> which stage it stopped working.
>
> miguel
>
> On Mon, 27 May 2002, Michael P. Carel wrote:
> > Finally i've set-up my AIX server with PHP and oracle support. Thanks
for
> > all who helps me for the configure setup.
> > Now I have a problem in oracle function regarding the retrieval of
entries
> > in the oracle table. The Ora_Fetch_Into function doesnt work properly to
me
> > or i have an error in which i dont know. I've written below the code
that i
> > used to test, it doesnt echo the value of $name and $email. My query
works
> > if i've enter it manually with my Oracle server. I really dont know why
im
> > just a newbie with this database(oracle) statement.
> >
> > Please help us here. Thanks in advance.
> >
> > <?PutEnv("ORACLE_SID=PROD");
> > PutEnv("ORACLE_HOME=/u01/app/oracle/product/7.3.3_prod");
> > $connection = Ora_Logon("apps","apps");
> > $cursor= Ora_Open($connection);
> >
> > $query = "select * from mikecarel";
> > $result = Ora_Parse($cursor,$query);
> > $result=Ora_Exec($cursor);
> > echo"<table border=1>";
> > echo"<tr><td><b>Full Name</b></td><td><b>Email Address</b></td></tr>";
> > while(Ora_Fetch_Into($cursor,$values)){
> > $name = $values[0];
> > $email = $values[1];
> > echo "<tr><td>$name</td><td>$email</td></tr>";
> > }
> > ora_close($cursor);
> > ora_logoff($connection); ?>
> >
> >
> >
> >
> >
> >
> >
> > Regards,
> > mike
> >
> >
> >
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
