Can I Filter ORACLE Errors During Execution of SQL*Form (3.0)?
Date: 9 Nov 92 15:39:44 GMT
Message-ID: <1992Nov9.153944.9014_at_cbfsb.cb.att.com>
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.
Scott D. Brenner
AT&T Consumer Communications Services
Basking Ridge, NJ
sbrenner_at_attmail.com
Received on Mon Nov 09 1992 - 16:39:44 CET