Sunday, January 6, 2013

Oracle DBMS_UTILITY error handling

Today we observed on weird issue when using one of the standard API which used work prior started giving error


ORA-06508: PL/SQL: could not find program unit being called

The easiest way to resolve this issue is by adding DBMS_UTILITY format_error_stack and format_call_stack to the when others block

This gave us the exact error of the internal package which was invalid



Begin
Null;
--keep your code
EXCEPTION
when others then

dbms_output.put_line(l_progress
'-when other exception'
DBMS_UTILITY.FORMAT_ERROR_STACK
'@'
DBMS_UTILITY.FORMAT_CALL_STACK);
END;

9 comments:

Sridevi Koduru said...
This comment has been removed by the author.
Path Infotech said...

Thanks for sharing the information

For more info : Oracle Certification Courses

Cub Training said...

Its impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.

Jessica Meri said...

Thanks for sharing these information. It’s a very nice topic. We are providing online training classesOracleAppsTechnicalOnlineTraining

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

Chinmaye Sri said...

Simply superb article thank you

Sujitkumar said...

Nice blog. Really helpful information about Oracle …. Please keep update some more…………