Re: [PHP4BETA] oci8 and empty LONG-Fields

On Fri, Feb 04, 2000 at 09:59:49AM +0100, Martin Trzaskalik wrote: > thies@digicol.de wrote: > > > > On Thu, Feb 03, 2000 at 07:22:30PM +0100, Martin Trzaskalik wrote: > > > php4 seems to react differently to empty LONG-Fields... > > > > which version are u using? (it should work) > > I am running Solaris 7 with Oracle 8i 8.1.6. I configured apache 1.3.9 > with php-3.0.14 (no problems) and php-4.0b3 (problem as described). > I tried Oracle 8.0.5 as well. Same problem. please try the cvs-version or a recent snapshot (snaps.php.net) and tell me if the problem is still there (i doubt it:) tc > > Martin > > > > > > > > > The following code > > > > > > $query = 'select * from test'; > > > $stmt = OCIParse($conn, $query); > > > $result = OCIExecute($stmt); > > > $count = OCIFetchInto($stmt, $array, OCI_ASSOC+OCI_RETURN_NULLS); > > > print "array=".serialize($array); > > > > > > leads to > > > > > > Warning: OCIFetchInto: ORA-01405: fetched column value is NULL > > > > > > when there is a LONG field that is NULL. > > > > > > If the warning comes up this row is not fetched. OCIFetchStatement > > > returns an array where only the column names are set. It contains > > > no values. > > > > > > With php3 I do not get the warning and the data is as expected. > > > > > > I would like to know wether this behavour is intentional and I have > > > to use NVL functions or will some day php4 react just like php3? > > > > > > Or is there maybe a work around? > > > > > > Martin > > > > > > -- > > > PHP 4.0 Beta Mailing List > > > <http://www.php.net/version4/> > > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > > For additional commands, e-mail: php4beta-help@lists.php.net > > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > > > > > > > -- > > > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > > Hammerbrookstr. 93 20097 Hamburg / Germany > > > > -- > > PHP 4.0 Beta Mailing List > > <http://www.php.net/version4/> > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > For additional commands, e-mail: php4beta-help@lists.php.net > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany