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
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
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.
Increase the SHARED_POOL_SIZE parameter to value greater than 50MB in initSID.ora file.
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!
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!