Re: Q: any idea what are we missing ?

Hi!
Your query results in no rows, so you must handle this exception.... /Bjoern

• Original Message ----- From: Juan Carlos Reyes Pacheco To: AmihayG_at_ectel.com Cc: oracle-l_at_freelists.org Sent: Wednesday, September 20, 2006 8:06 PM Subject: 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