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: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 20 Sep 2006 16:49:51 -0400
Message-ID: <cd4305c10609201349t25998a1axb8d18fa7206a7dbf@mail.gmail.com>


Hi Bjrn,
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, Bjrn Drr 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 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.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
Received on Wed Sep 20 2006 - 15:49:51 CDT

Original text of this message

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