Re: Q: any idea what are we missing ?

  • From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
  • To: "Bjørn Dörr Jensen" <b.d.jensen@xxxxxxx>
  • Date: Wed, 20 Sep 2006 16:49:51 -0400

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006