Many developers want to make fully documented custom error messages in their PL/SQL applications.

Best of all, you can fully integrate the error messages the same as any other ORA-xxxx message. 

But how do we document a new error and make it work with the oerr utility?

Adding custom Oracle error messages is not difficult.  Any PL/SQL programmers know that they can create any custom ZZZ-1234 error number to be returned by their code.
 
You can use utl_file.put_line to write anything you want into the alert log, and you can use this same approach to write customized error messages. 

For example, here we write a ZZZ-1234 custom error message to the Oracle alert log:

-- ******************************************************
-- Write a message to the alert log!!!
-- ******************************************************
alter system set utl_file_dir = ‘:alert_loc’);
utl_file.fopen(':alert_loc',’alertprod.log’,'W');
dbms_output.put_line('ZZZ-1234  This guy has bad credit');
 
But writing s custom alert message is only half the story, you must also document the error cause and error action within the Oracle error message utility (oerr).

Read the full article and see how to integrate your own error message directly inside the Oracle siftware:

http://www.dba-oracle.com/t_create_custom_oracle_error_message.htm

*****************************************

Need a Health Check?

Oracle is the world's most complex and robust database and there are hundreds of sub-optimal settings that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author. Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training. Just call 800-766-1884 for details, and check out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf 

*****************************************

There's Always Room at the Top

Burleson Consulting continues to grow as the Oracle community recognizes that high quality Oracle support and training is a cost effective option in these tough economic times.

If you have distinguished yourself in your Oracle career and are ready to step up and enjoy the rewards of joining the ranks of America's top tier support consultants we would like to hear from you.

Evidence of high achievement as an Oracle professional might include publication of books and articles for the Oracle community, achieving an advanced degree from a competitive university and seeking out hands-on experience with complex databases. See here for details and a full qualifications list:

http://www.dba-oracle.com/jobs.htm