Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why isn't it catching it?

Why isn't it catching it?

From: <wweng_at_ei.org>
Date: 10 May 1999 20:02:19 GMT
Message-ID: <7h7e0b$pe8$1@eipipeline.ei.org>


I have the following query:

SELECT id INTO custid FROM www_cust.customer_data WHERE username = uname AND passwd = passwd;

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 Received on Mon May 10 1999 - 15:02:19 CDT

Original text of this message

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