ORA - 01405 - fetched column value is NULL

[uri bargil]

Im using a select statement in order to retreive data from the DB to my
c program using OCI.
I use ORACLE DB 8 , OAS 4.0.7 on SUN SOLARIS 2.6 .
My select statement is :
"SELECT a,b,c FROM myTable WHERE x=:x"
a is a varchar2 , b&c are numbers in the DB.
In my code a is a text * b is an integer and c is long.
I get the Error in the title for executing yhis statement?
The DB does NOT have a NULL value at any column !
1)What can cause this problem ?
2)Is it because the OCIDefineByPos() ;
In the ORACLE TECHNET website they suggest to solve this problem with
NVL functions - What are NVL functions , Where they can be found and how
should I use them.
Thank you
Uri
E-mail :u...@trans-planet.com

[un2...@my-dejanews.com]

NVL(null value) function can be used as follows - SELECT a,b,c FROM myTable
WHERE x=:x can be written as SELECT nvl(a,'x'), nvl(b,'y'), nvl(c,'z') FROM
myTable WHERE x=:x; This indicates that the select will return 'x' as a value
when the value in the column "a" is null for a certain row. The same applies
to b & c. Hope this helps.

In article <372DCE76...@trans-planet.com>,

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[un2...@my-dejanews.com]

[un2...@my-dejanews.com]