SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error - Fetched column value is Null

561434Jan 27 2008 — edited Jan 31 2008

Hi Techies,

I get this error ORA-01405: fetched column value is NULL, when I run a Select statement defined inside a Cursor from Pro*C code. The surprising thing is that I get this error inspite of all the columns being fetched using nvl() function. I, infact, checked the data thoroughly to find any nulls among the columns being selected but could not find anything. I believe this error could be possible only when used inside a cursor. Are there any chances that the way the cursor is managed by Oracle is a cause of this error?

Any suggestions or possiblities are welcome.

Regards
Sreeni

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2008

Added on Jan 27 2008

14 comments

4,875 views