Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Can I Filter ORACLE Errors During Execution of SQL*Form (3.0)?

Can I Filter ORACLE Errors During Execution of SQL*Form (3.0)?

From: scott.d.brenner <sbrenner_at_cbnewsb.cb.att.com>
Date: 9 Nov 92 15:39:44 GMT
Message-ID: <1992Nov9.153944.9014@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 - 09:39:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US