Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use dbms_metadata.get_ddl to report XSL stylesheets not loaded correctly errors. I hope you will get something after reading this article. Let's discuss it together.

After using dbms_metadata.get_ddl to report XSL stylesheets not loaded correctly errors, as shown below

SQL > select dbms_metadata.get_ddl ('TABLE','MY_TBL_JZJL','QYWS_YYGJ') from dual

ERROR:

ORA-39212: installation error: XSL stylesheets not loaded correctly

ORA-06512: at "SYS.DBMS_METADATA", line 6069

ORA-06512: at "SYS.DBMS_METADATA", line 8666

ORA-06512: at line 1

The reason for this problem is that the XSL stylesheet used by the data pump metadata API is not properly loaded into the Oracle dictionary table "sys.metastylesheet" and can be reloaded (sysdba privileged user) in the following way.

SQL > exec dbms_metadata_util.load_stylesheets

PL/SQL procedure successfully completed.

After executing the sql that queries the metadata above:

SQL > select dbms_metadata.get_ddl ('TABLE','MY_TBL_JZJL','QYWS_YYGJ') from dual

DBMS_METADATA.GET_DDL ('TABLE','MY_TBL_JZJL','QYWS_YYGJ')

CREATE TABLE "QYWS_YYGJ". "MY_TBL_JZJL"

"CODE" VARCHAR2 (18) NOT NULL ENA

Can be executed correctly.

After reading this article, I believe you have a certain understanding of "how to use dbms_metadata.get_ddl to report XSL stylesheets not loaded correctly errors". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.