how get ddl of JAVA CLASS? dbms_meta.get_ddl do not work with java_source
785849Nov 8 2010 — edited Nov 8 2010hi all,
i can not generate the DDL of java class in 10g r2 as below.
sys@RPTDB > select dbms_metadata.get_ddl('JAVA_SOURCE','BRStatus','HDADMIN') from dual;
ERROR:
ORA-31603: object "BRStatus" of type JAVA_SOURCE not found in schema "HDADMIN"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2806
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
actually, the object exists.
sys@RPTDB > select object_name,object_type,owner from dba_objects where object_name='BRStatus';
OBJECT_NAME OBJECT_TYPE OWNER
-------------------- -------------------- ----------
BRStatus JAVA CLASS HDADMIN
thanks for any inputs.