Re: Q: any idea what are we missing ?

  • From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
  • To: AmihayG@xxxxxxxxx
  • Date: Wed, 20 Sep 2006 14:06:16 -0400

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

Other related posts: