Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Determining if fetched data is NULL using Method 4
Does anyone know how to determine if data that has been fetched from Oracle using Method 4 dynamic sql is Null. I am using method 4 to fetch a block of data into a host array. I then iterate thru the array and process the data. In the Oracle examples, sqlnul() is used to reset the Null/Not Null allowed bit before reallocating memory as required by the query....But....I cant find a way to determine if a field contained a null for a particular field in a record record after it has been fetched. It appears that when coercing to an int or float that the result is not always 0 when a null value is encountered. Any suggestions would be greatly appreciated!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 09 2000 - 11:34:13 CST
![]() |
![]() |