Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

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>