Hi..
I obtain this error:
I check my configuration, and I have this:
------
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
SQL> select distinct owner,name from dba_source where lower(NAME)='dbms_java';
OWNER NAME
------------------------------ ------------------------------
SYS DBMS_JAVA
SQL> select comp_id, comp_name, version, status from dba_registry;
| COMP_ID | COMP_NAME | VERSION | STATUS |
| CATALOG | Oracle Database Catalog Views | 10.2.0.5.0 | VALID |
| CATPROC | Oracle Database Packages and Types | 10.2.0.5.0 | VALID |
| OWM | Oracle Workspace Manager | 10.2.0.5.0 | VALID |
| EM | Oracle Enterprise Manager | 10.2.0.5.0 | VALID |
| RAC | Oracle Real Application Clusters | 10.2.0.5.0 | VALID |
| XDB | Oracle XML Database | 10.2.0.5.0 | VALID |
| CATJAVA | Oracle Database Java Packages | 10.2.0.5.0 | REMOVED |
--------------
when I execute initjvm.sql, I obtain this output:
--------------------
SQL> @initjvm.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
Package body created.
No errors.
Call completed.
Call completed.
Call completed.
Table created.
Table created.
Table created.
Index created.
Index created.
Index created.
Package created.
Package body created.
Package created.
Package body created.
Call completed.
PL/SQL procedure successfully completed.
alter system flush shared_pool
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
View created.
drop public synonym javasnm
Call completed.
Synonym created.
Grant succeeded.
COUNT(*)
----------
0
PL/SQL procedure successfully completed.
JVMRMACTION
--------------------------------
FULL_REMOVAL
drop package dbms_java
drop PUBLIC SYNONYM dbms_java
drop FUNCTION dbj_long_name
drop function "NameFromLastDDL"
drop PUBLIC SYNONYM "NameFromLastDDL"
drop FUNCTION dbj_short_name
drop PUBLIC SYNONYM dbj_short_name
PL/SQL procedure successfully completed.
Package created.
Package body created.
Synonym created.
Grant succeeded.
Function created.
Function created.
Synonym created.
Grant succeeded.
Function created.
Synonym created.
Grant succeeded.
no rows selected
select dbms_java.longname('foo') from dual
**\***
ERROR at line 1:
ORA-29538: Java not installed
----------------
and crash the procedure...
that is all, please I need some of help...
Thank's...
PD. sorry but my english not is good.
Alberto