Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: Error while computing shortname ??

    I have written some Java which is to be loaded into Oracle as stored procedures. It worked perfectly in my office database which is Oracle 9i. However when i try to load the java class into our clients database which is also Oracle 9i, i got the error stated above.

    Here is the full error listing:-

    C:\Documents and Settings\Administrator>loadjava -user map/map@geo
    -resolve c:\bdy.class
    Error while computing shortname of bdy
    ORA-06550: line 1, column 13:
    PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    errors : class bdy
    ORA-29521: referenced name java/lang/Object could not be found
    ORA-29521: referenced name java/lang/String could not be found
    The following operations failed
    class bdy: resolution
    exiting : Failures occurred during processing

    What gives? Thanks in advance!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    fact: Oracle Server - Enterprise Edition 8.1.7
    fact: MS Windows 2000
    symptom: loadjava fails
    symptom: ORA-06550: line %s, column %s:\n%s
    symptom: PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
    cause: Not enough shared pool memory.
    fix:
    Increase the SHARED_POOL_SIZE parameter to value greater than 50MB in initSID.ora file.

  3. #3
    Join Date
    Jan 2004
    Posts
    14
    I increase the Shared_Pool_size, however the error still ocurs. Now currently ths shared_pool_size is running 200MB. BTW i forgot to add that the client's database is running on a UNIX platform and the one in my office is a Win2K Advance Server. How can i check if the Oracle is JVM equiped/installed? Thanks a bunch!

  4. #4
    Join Date
    Jan 2004
    Posts
    14
    I recently came to discover that my client's Oracle 9i database (unix platform) is installed without a DBMS_JAVA package which in turn forbids me to load java stored procedures. Can someone help me or tell me how do i install the package? Bear in mind, the database is the REAL thing not a testing machine. Thanks!

Posting Permissions

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