| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> Can I Filter ORACLE Errors During Execution of SQL*Form (3.0)?
I'm running SQL*Forms 3.0.16.4.1. I'm creating applications for end-users who don't know anything about databases, let alone Oracle specifically, or such things as "duplicate key in index" errors. Does anyone know if there's a way I can "filter" Oracle system errors during the running of a form? What I'd like to do is capture an error such as a duplicate key in index problem and present the user with a more friendly and meaningful message than
"FRM-40508: ORACLE error -- unable to INSERT record."
Even if the user could handle [Display Error], I don't think that
"ORA-00001: duplicate key in index"
would mean much to them.
If anyone has any clue as to how I could do this, I'd really like to hear it. Thanks in advance for your help. Please respond via e-mail to sbrenner_at_attmail.com; I'll post a summary of responses in a few days.
 |
 |