Re: [PHP] Ora_Fetch_Into function problem

2002-05-27 Thread Michael Virnstein
if you are a newbie to oracle, don't forget to use bind variables in your queries, if this is possible in your Oracle Version. bindvars are placeholders for values in an oracle query, to which you bind your value on runtime. the advantage in using bind variables is, that oracle doesn't have to com

Re: [PHP] Ora_Fetch_Into function problem

2002-05-27 Thread Michael P. Carel
ooopp...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

Re: [PHP] Ora_Fetch_Into function problem

2002-05-27 Thread Michael P. Carel
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

Re: [PHP] Ora_Fetch_Into function problem

2002-05-26 Thread Michael P. Carel
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. "; exit; } $cursor= Ora_Open($connection); if($cursor==false){ echo Ora_ErrorCode($connection).":". Ora_Error($connecti

Re: [PHP] Ora_Fetch_Into function problem

2002-05-26 Thread Miguel Cruz
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