PINE-DFREEMAN> BEGIN
2 UPDATE emp
3 SET saL =3D100
4 WHERE ename =3D 'POKEY';
5 IF SQL%NOTFOUND THEN
6 dbms_output.put_line('POKEY NOT FOUND');
7 END IF;
8 END;
9 /
POKEY NOT FOUND
PL/SQL procedure successfully completed.
I got the method from Scott Urman's Oracle 8i Advanced PL/SQL =
Programming Book page 5. I am by no
means the world's best PL/SQL programmer, or even the best within 100 =
feet of where I am sitting <g>
but this particular event can be handled without an exception.
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Anu
> Sent: Thursday, April 29, 2004 5:58 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: a pl/sql question
>=20
>=20
> I think you need exception here. It will error out if no row=20
> found. It will not go to :
> =20
> IF SQL%NOTFOUND THEN.=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------