Oracle

The function SQLERRM can be used to return an Oracle error message in PL/SQL to the calling environment.
In Oracle 10g the value which the function SQLERRM can return is something like 512,
prior to 10g it was 255.
 
Therefore Oracle recommends not to use this function but rather use
DBMS_UTILITY.FORMAT_ERROR_STACK instead of …

Link to the original site

Tags: Error Message, Error Stack, Format Error, Oracle, Oracle 10g, ORACLE BLOGS, Oracle Error, Pl Sql, Sqlerrm

Related posts

• RMAN puzzle: database reincarnation is not in sync with catalog (0)
• Join us at Microsoft TechEd Europe and UKOUG (0)
• Consuming Web Services using PL/SQL… (0)
• Yet another External XML parse error: for BATCH CLOSE processing of IBYSCHEDULER module .. this time (0)
• Working with Automatic Workload Repository Performance Snapshots (0)
• What Error (0)
• Vista installer available for Discoverer 10g Administrator and Desktop (0)
• Utl_compress, gzip and zlib (0)
• Using Oracle Database 11g Hierarchical Profiler in SQL Developer (0)
• Using 11g Database with SOA Suite 10.1.3 (0)