«« Next » « Previous
«« Next » « Previous

Link Details

Link 3845 thumbnail
User 72473 avatar

By ga79820
via orafaq.com
Published: Sep 25 2006 / 17:37

A common practice for handling errors in PL/SQL procedures is to catch all errors in the top-most database layer and convert them into error codes and human readable messages for client applications. This technique is a relict from the past and, in fact, a very bad practice from today's perspective, since it can lead to data corruption.
  • 10
  • 0
  • 355
  • 101

Comments

Add your comment
User 200494 avatar

kayess replied ago:

0 votes Vote down Vote up Reply

At first glance I thought this was going to offer some terrible advice, but actually it's pretty good.

What I don't understand though is that anybody thought that destroying the error handling in the SQL server was a good idea. That anybody *still* believes that beggars belief!

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (10)



Voters Against This Link (0)