Error message: ORA-01405: fetched column value is NULL
Posted: 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.
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.
Code: Select all
EXEC SQL EXECUTE
BEGIN
: W07-TAB-POST := Get_db.be_free();
END;
END-EXEC.
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.