How can I interpert error codes returned in PLSQL procedure?

Once upon a time in a universe far away, I knew this, but now I jave forgotten :-)

I'm trying to get a PLSQL procdure that I used several years agao to study some things about indexes to run on my nice new Oracle server. There are several things that are different about the new one (7.3.4.5 if it matters, so I;m certain that my problem has to do with that.

The real dificulty lies in the fact that I can't interpet the error code the procedure is returning. Like a good little programer, I did put in a catch all exception hadnler, and it's being trigered. But to use oerr to give me the text, I need to now the prefix as well as the error code :-(

How can I figure this out?

Here is teh message I'm getting:

Other Exception -947 c_table_name B100 v_table_name B100

And it's being generated by this peice of code:

DBMS_OUTPUT.PUT_LINE('Other Exception ' || error_code || ' c_table_n ame ' || c_table_name || ' v_table_name ' || c_table_name);

Thanks for re-educating me on this!

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin