Home » SQL & PL/SQL » SQL & PL/SQL » Error Handling
Error Handling [message #37773] Wed, 27 February 2002 09:52 Go to next message
aish
Messages: 44
Registered: March 2001
Member
hi

what is the Difference between Error Handling and Exception Handling.

Thanks,
Aish
Re: Error Handling [message #37775 is a reply to message #37773] Wed, 27 February 2002 12:20 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
This is subjective, but I would consider exceptions (in the Oracle sense) to be a subset of errors.

Errors would include these Oracle exceptions (no_data_found, a constraint violation, etc.) as well as business rule errors (trying to assign a student to two simultaneous classes, trying to delete a posted invoice, etc.).

The handling for each of these is dependent on the requirements and the context. You may return a soft message back to the app, a fatal error, or suppress the error entirely - it just depends.
Previous Topic: diff btn rowid and rownum
Next Topic: how to handling clob in Ado vc++
Goto Forum:
  


Current Time: Fri Apr 19 10:09:54 CDT 2024