We receive the following message: ORA-29540 + ORA-06512 when running this script:
dir := arc_xpi.GetTempDir;
This script should open a preconfigured Java-Package (another application)
and the package should start its job.
Both the database (10gR2) and the application are on the same machine.
We also ran:
select status, count(status) from all_objects
where object_type='JAVA CLASS'
group by status;
All valid. Furthermore, we didn't find the initplsj.sql in the ORACLE_HOME/rdbms/admin directory. This script should fix the problem.
Any help would be greatly appreciated.
Which Oracle version? if running on Ora10g I understand initplsj.sql is not needed anymore - please anybody correct me if I'm wrong.
oerr ora 29540
29540, 00000, "class %s does not exist"
// *Cause: Java method execution failed to find a class with the indicated name.
// *Action: Correct the name or add the missing Java class.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width