Menu
▾
▴
#16 Improved Error Messages from Exceptions
Hopefully, I haven't missed anything. I am not sure why this is not already in place. The UTPLSQL.runprog and UTPLSQL.test procedures return SQLERRM when an exception is raised. (We don't run test suites, so I am not sure about that procedure.) By replacing SQLERRM with "dbms_utility.format_error_stack || dbms_utility.format_error_backtrace", the return error messages are much more informative. Perhaps this has not been done for compatability with database releases before Oracle10g?
I pulled the current version (r185) of "ut_plsql.pkb" from "utplsql/trunk/source":
Line 412: || SQLERRM
Line 433: || SQLERRM,
Line 957: || SQLERRM,
Line 1107: || SQLERRM,
You're reasoning is correct - there's still a lot of old code in here. While some newer Oracle features have been included (with bespoke conditional compilation tags to ensure backwards compatibility), there's still plenty of room for this to be improved further.