Error message: ORA-01405: fetched column value is NULL

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Sandrit
Member
Posts: 6
Joined: Fri Sep 11, 2015 11:06 pm

Error message: ORA-01405: fetched column value is NULL

Post by Sandrit » Fri Sep 11, 2015 11:58 pm

This is my (PL/SQL) call. I want to fetch data from this package Get_db.be_free.

Code: Select all

EXEC SQL EXECUTE
           BEGIN
               : W07-TAB-POST := Get_db.be_free();              
            END;
END-EXEC.
The call returns a null value, and I get this error message: ORA-01405: fetched column value is NULL
I understand that Indicator or NVL can be used to solve this problem. But I don’t understand how to use Indicator or NVL.

Can someone please guide me through the procedure.
Thanks in advance.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others