Home » SQL & PL/SQL » SQL & PL/SQL » internet app: handling error messages
internet app: handling error messages [message #1592] Wed, 15 May 2002 08:05 Go to next message
Jim Reed
Messages: 2
Registered: May 2002
Junior Member
I have written an app in ASP and VBScript that does not handle errors from Oracle. Specifically, I have constraints ensuring referencial integrity. For example I submit a an SQL delete command but if this violates a constraint the Oracle error message is displayed on my browser. It is as though my script never regains control once the constraint is violated. I want to handle these errors more gracefully. What am I missing? thanks
Re: internet app: handling error messages [message #1594 is a reply to message #1592] Wed, 15 May 2002 08:31 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive, you can trap the errors using some kind of exceptions like On_error.
Previous Topic: backups2
Next Topic: Getting rid of decimals in the date
Goto Forum:
  


Current Time: Wed Apr 24 20:07:24 CDT 2024