执行不了 select dbms_metadata.get_ddl

执行下面的SQL出现了错误。

> select  dbms_metadata.get_ddl('TYPE', 'AA', 'LIF') from dual;

>

 

ORA-39212: installation error: XSL stylesheets not loaded correctly
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7398
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7447
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9453
ORA-06512: at "SYS.DBMS_METADATA", line 1919
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

 

 

改正的的原因，先执行下：

 

SQL> exec sys.dbms_metadata_util.load_stylesheets

PL/SQL procedure successfully completed.

 

再执行 上面的就可以了。