How do I capture content of an ODBC error message from Oracle?

From: sjlevine34 (sjlevine34_at_discussions.microsoft.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 15:15:01 -0800

I am using Microsoft Access as a front end for an Oracle database. All of
the data validation is done in the Oracle Tables through the use of triggers.
 The error messages are ones I coded for as user-defined exceptions with
concise user-friendly descriptions. They display in their entirety in the
forms I use to maintain the tables. For example, the following error message
may be displayed:

   ODBC--insert on a linked table 'OBI_DONOR_EMAIL' failed.

  [Oracle][ODBC][Ora]ORA-20700: Email address cannot be blank.

  ORA-06512: at "OBIEBIS.OBI_DONOR_EMAIL_T2", line 23
  ORA-04088: error during execution of trigger 'OBIEBIS.OBI_DONOR_EMAIL_T2'
   (#20700)

I would like to, through the use of the form on error event and the mid()
function, display the error message as "Email address cannot be blank.".

Despite extensive searching, I have not been able to find the object holding
the message "[Oracle][ODBC][Ora]ORA-20700: Email address cannot be blank.
<LF><LF> ORA-06512: at "OBIEBIS.OBI_DONOR_EMAIL_T2", line 23 <LF> ORA-04088:
error during execution of trigger 'OBIEBIS.OBI_DONOR_EMAIL_T2' (#20700)". I
know it has to be there because the message box displays the error after
completion of the form on error event procedure.

Does anyone know where this error message resides in access and how I can
get at it during the form error event procedure?

sjl 

-- 
sjl

Relevant Pages

  • Re: Saving a form discards the digital certificate
    ... they get an error message ... We much prefer lengthy well written postings to short postings without ... significant amount of time researching some alternatives and actually ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: INSERT INTO Query Question
    ... query I get the following response: "Microsoft Access can't append all the ... records in the append query. ... the following error message as I attempt to run an append query: ... FROM [prospect list]; ...
    (microsoft.public.access.queries)
  • Re: A real learners question!
    ... I have renamed everything without spaces but I still get the error message ... I currently get an error message saying "Microsoft Access can't find macro ... event of the details form. ...
    (microsoft.public.access.forms)
  • Re: Access 2003 Error: 3218 Could not update; currently locked
    ... stuart wrote: ... She said that she did not get any type of error message ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • aspx Error Message
    ... following error message is issued: ... The Access database is not opened by another so I don't know why it is being ... Microsoft Access can't open the database because it is missing, ...
    (microsoft.public.dotnet.framework.aspnet)