ora-39212 ora-06502

在11g上用DBMS_MEDATA包的时候报错

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

ORA-39212: installation error: XSL stylesheets not loaded correctly Cause:  The XSL stylesheets used by the Data Pump Metadata API were not loaded correctly into the Oracle dictionary table "sys.metastylesheet." Either the stylesheets were not loaded at all, or they were not converted to the database character set. Action:  Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.

解决方法是重建下sys.metastylesheet就可以

exec dbms_metadata_util.load_stylesheets;

 

执行完后,结果还有问题,PLSQL报错ora-06502,但是在sqlplus中执行 

begin
  dbms_output.enable(10000000);
end;

后就没问题了,但是PLSQL中还是有问题,奇怪