Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Determining if fetched data is NULL using Method 4

Determining if fetched data is NULL using Method 4

From: <jgaiche_at_my-deja.com>
Date: Thu, 09 Nov 2000 17:34:13 GMT
Message-ID: <8uen6m$46i$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US