Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Q: any idea what are we missing ?

Re: Q: any idea what are we missing ?

From: Bjrn Drr Jensen <B.D.Jensen_at_gmx.net>
Date: Wed, 20 Sep 2006 22:19:23 +0200
Message-ID: <005201c6dcf2$107ef570$6601a8c0@LENO>


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

  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 lnea 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", lnea 5
  ORA-06512: en lnea 4




--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 20 2006 - 15:19:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US