Re: [PHP4BETA] oci8 and empty LONG-Fields

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. 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