oooppssss...sorry just found out why. I just need to have Ora_Commit()
function after all the queries to totally set the data to the database.
Im querying a data which is not commited yet to the oracle database.
Sorry for that I'm just a newbie in oracle.
Thanks to all..
mike
> I've recently found out that the Ora_Fetch_Into function cannot get a
small
> value of the tables data. We've tried to fetch other tables which have a
> large amount data ,and it succeeds. The queried values echoed
successfully.
> Is there any idea why? im using PHP4.2.1 oracle7.3.3
>
>
> Regards,
> Mike
>
>
>
>
>
> > 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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
