no_data_found from select ... into
SQL>
SQL> create table t ( object_id primary key, object_name )
2 organization index
3 as
4 select object_id, object_name from all_objects;
Table created.
SQL>
SQL> create or replace procedure implicit
2 as
3 l_object_name t.object_name%type;
4 begin
5 for i in 1 .. 30000
6 loop
7 begin
8 select object_name into l_object_name
9 from t
10 where object_id = i;
11 exception
12 when no_data_found then
13 l_object_name := null;
14 end;
15 end loop;
16 end;
17 /
Procedure created.
SQL>
SQL> drop table t;
Table dropped.
SQL>
Related examples in the same category