Listing Errors On Oracle

Been a bit quiet of late, so here’s something for the notepad to kick off new year.

Error (EP)
Image via Wikipedia

Upon compiling a custom type into an Oracle schema, I was left with an  “Invalid Object” error message when attempting to use it.

Error: PLS-00905: object MY_SCHEMA.MY_TYPE is invalid

Line: 245Text: PROCEDURE p_my_proc(pt_my_param IN my_type);

The type declaration itslef had seemingly compiled without an issues, so I was a little stumped as to what the problem was.

Some brief enquiries led me in the direction of the user_errors table:

select * from user_errors

And, from that I was able to determine the cause of my problems (which are actually too boring to post here).

Leave a Reply