ORA-01403: no data found

ORA-01403: no data found

ORA-01403: no data found

Cause:

A SELECT INTO statement was executed and no rows were returned.

Solution:

Set the no_data_found exception or correct the SELECT statement.

Example:

declare
    v_name varchar2(255);  
begin
    select name 
    into v_name 
    from books 
    where id=00011872;
    dbms_output.put_line('The name is: '||v_name);
end;

Output:

ORA-01403: no data found

Correct

declare
    v_name varchar2(255);  
begin
    select name 
    into v_name 
    from books 
    where id=4;
    dbms_output.put_line('The name is: '||v_name);
end;

Output:

The name is: Learn SQL