plsql – Oracle PL/SQL package errors (ORA-04063 and ORA-06508) when called from a java application

plsql – Oracle PL/SQL package errors (ORA-04063 and ORA-06508) when called from a java application

You need to find the compilation errors. If youre using an IDE like SQL Developer then theres a tab for that. If youre using SQL*Plus you should get the errors with the show errors command.

In any environment you can always run this:

 select * from user_errors
 where name = SEARCH_TRAILER

(assuming youre connected as the package owner, otherwise use ALL_ERRORS).

plsql – Oracle PL/SQL package errors (ORA-04063 and ORA-06508) when called from a java application

Leave a Reply

Your email address will not be published. Required fields are marked *