Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why isn't it catching it?
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