Been a bit quiet of late, so here’s something for the notepad to kick off new year.
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).