Re: Q: any idea what are we missing ?

Hi amihay,

SQL> declare
  2 a number;
  3 begin
  4
  5 select 1 into a from dual where 1 = 0;   6 end;
  7 /
declare
*

ERROR at line 1:
ORA-01403: no se han encontrado datos
ORA-06512: en lİnea 5

SQL> select test from dual;

      TEST

SQL> declare
  2 a number;
  3 begin
  4 a := test;
  5 end;
  6 /
declare
*

ERROR at line 1:

ORA-01403: no se han encontrado datos
ORA-06512: en "DAZ.TEST", lİnea 5
ORA-06512: en lİnea 4

--
http://www.freelists.org/webpage/oracle-l