ORA-06550: line 0, column 0: PLS-00907: cannot load library unit USAGE.SP_MISSING_FILE_CASE_CLOSURE (referenced by)

So, I got this error message

"failed with the following error: "ORA-06550: line 0, column 0: PLS-00907: cannot load library unit USAGE.SP_MISSING_FILE_CASE_CLOSURE (referenced by )". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

sometimes, but sometimes my SSIS job runs normally. Can someone provide me with some kind of solution? I cannot see any pattern in it's failure except PROCEDURE which is always the same.

I have searched google for answer or anything that can help me but I was not able to find a thing. Can anyone please help me?
Vladimir TodorovAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
I would get with the Oracle DBA and see what that procedure does and if it references external programs.

If you can log the failure times, the Oracle DBA should be able to help you track down what is causing the failure.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.