Re: Why isn't it catching it?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 10 May 1999 20:44:14 GMT
Message-ID: <373f44c3.31033623@192.86.155.100>

A copy of this was sent to wweng_at_ei.org (if that email address didn't require changing) On 10 May 1999 20:02:19 GMT, you wrote:

>I have the following query:
>
>SELECT id INTO custid FROM www_cust.customer_data WHERE username = uname
>AND passwd = passwd;
>

     ^^^^^^^^^^^^^^^^

is the same as 1=1

you probably are NEVER missing a row since this is the same as:

select id into custid from www_cust.customer_data where username = uname;

change the name of your PASSWD plsql variable to something like p_passwd (p for parameter)...

>and the exception:
>
>EXCEPTION
>
> WHEN NO_DATA_FOUND THEN
> ....
>
>
>But somehow when there is no row returned, the exception is not being caught.
>
>Is there any explanation for this? And how can i fix it to let it catch
>the exception again?
>
>
>Thanks in advance.
>
>wei

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon May 10 1999 - 15:44:14 CDT