Re: Q: any idea what are we missing ?
- From: Bjørn Dörr Jensen <B.D.Jensen@xxxxxxx>
- To: <juancarlosreyesp@xxxxxxxxx>, <AmihayG@xxxxxxxxx>
- Date: Wed, 20 Sep 2006 22:19:23 +0200
Hi!
Your query results in no rows, so you must handle this exception....
/Bjoern
----- Original Message -----
From: Juan Carlos Reyes Pacheco
To: AmihayG@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
