Pretty common oracle error. Raised when you are trying to fetch data from sql into a pl/sl variable and the sql does not return any data. >> Using the data from this schema
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
SQL> select count(*) from scott_emp where empno = 9999; COUNT(*) ---------- 0 SQL> declare l_ename scott_emp.ename%type; l_empno scott_emp.empno%type := 9999; begin select ename into l_ename from scott_emp where empno = l_empno; end; / declare * ERROR at line 1: ORA-01403: no data found ORA-06512: at line 5 |
What to do next 1. Re-Raise…