Hi!
We receive the following message: ORA-29540 + ORA-06512 when running this script:
declare
dir varchar2(4000);
begin
dir := arc_xpi.GetTempDir;
end;
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.