i'm looking to know about exceptions [message #1349] |
Tue, 23 April 2002 08:03 |
pavani
Messages: 32 Registered: April 2002
|
Member |
|
|
hi
i'm working on sql and pl/sql.i'm looking to know over exceptions. plz help me in knowing and where to use and what for we use these exceptions.
if possible plz eplain with an example .
thank u for u'r kindly help
|
|
|
Re: i'm looking to know about exceptions [message #1418 is a reply to message #1349] |
Sun, 28 April 2002 01:33 |
yram
Messages: 75 Registered: February 2001
|
Member |
|
|
hi
The exceptions are error handlers they are used to handle error which occur during DML statement.
ex.
select 34/0 from dual;
This is a type of error since we can't divide a number by zero.
ex 2.
select * from dept where deptno=55;
this will return a error no data found since in the dept table the value of the deptno ranges from 10 to 40 only.
Thus the exceptions are used to handle the errors and trap the errors and give our own messages so that the end user is able to understand the error.
there many type of exceptions.
user defined exception
pre defined exception
where others
etc.,
i think this will do for you please refer a good book it has a large number of example.
if you need my example do mail me
Regards
yram
|
|
|