Re: Q: any idea what are we missing ?

Hi Bjørn,
the point is when you execute the function through a query the exception is
not raised, but yes when you execute in a block.

On 9/20/06, Bjørn Dörr Jensen <B.D.Jensen@xxxxxxx> wrote:

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

----- Original Message -----
*From:* Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
*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




--
----------------------------------------
http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

Other related posts: