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

[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.