DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ora-29540

  1. #1
    Join Date
    Oct 2009
    Posts
    5

    Ora-29540

    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.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Which Oracle version? if running on Ora10g I understand initplsj.sql is not needed anymore - please anybody correct me if I'm wrong.

    Code:
    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.

  3. #3
    Join Date
    Oct 2009
    Posts
    5

    DB-Version

    DB-Version: 10gR2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width