Page 1 of 1

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

Posted: Fri Sep 11, 2015 11:58 pm
by Sandrit
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.