Re: Is there a table containing ORACLE error codes?
Date: 18 Mar 1993 16:04:44 GMT
Message-ID: <1oa6isINNqln_at_ef2007.efhd.ford.com>
In article <1993Mar17.224340.23301_at_cnw01.storesys.coles.oz.au> andrew_at_cnw01.storesys.coles.oz.au (Andrew May) writes:
>In <1nq7vnINNnp6_at_ef2007.efhd.ford.com> wwm_at_ef5003.efhd.ford.com (Bill Meahan) writes:
>
[extract from original post deleted]
>Bill,
> I assume when you say "user program" that you are using one of the
>Oracle programmatic interfaces such as Pro*Cobol.
>
[ stuff deleted ]
Funny how people make assumptions about what someone else is doing :-)
The first batch of e-mail replies assumed I was running from a Unix command line and graciously pointed out the 'oerr' facility (which led to the eventual solution but wasn't directly applicable).
The second batch, and this posting, assume I'm using the programmatic interface from C or [shudder] COBOL.
In fact, I'm using neither!
My particular application is a client-server job based on Microsoft Excel running on a user's PC connected to ORACLE (on an HP-UX box that acts as a data server) via Q+E Database Library and SQL*Net TCP/IP. Users don't even HAVE a login id to the server, just ORACLE id's/passwords.
Nevertheless, the 'oerr' approach led to the solution --
oerr is just a shell/awk script that reads data from files in $ORACLE_HOME/rdbms/mesg. A plethora of files in that directory contain the error codes/descriptions in a variety of languages for a variety of ORACLE products. It was simple to create a table in the database and cobble up a script to load it with the data from the appropriate files. That way, the client program can query the database for the description (assuming the error isn't "no connection" :-) ].
Thanks to all who replied - you helped a great deal.
-- Bill Meahan |EFHD Information Systems Staff Plant Floor Systems Specialist |Ford Motor Company wwm_at_ef5003.efhd.ford.com | +1 313 487 6122 ..!fmsrl7!pmsmam!wwm |I'm not paid to speak for Ford!Received on Thu Mar 18 1993 - 17:04:44 CET