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_at_gmx.net> wrote:
>
> Hi!
> Your query results in no rows, so you must handle this exception....
> /Bjoern
>
> ----- Original Message -----
> *From:* Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
> *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.oracleboliviaspecialists.com/

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

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

--
http://www.freelists.org/webpage/oracle-l