Re: [PHP4BETA] oci8 and empty LONG-Fields

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