SAP Knowledge Base Article - Preview

2530308 - ORA-20001 shown by DBMS_QOPATCH

Symptom

Executing any Subprogram of DBMS_QOPATCH produces errors like below:

SQL> select xmltransform(dbms_qopatch.get_opatch_list, dbms_qopatch.get_opatch_xslt) from dual;
ERROR:
ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 704
ORA-06512: at "SYS.DBMS_QOPATCH", line 839

no rows selected

SQL> select xmltransform(dbms_qopatch.get_opatch_bugs, dbms_qopatch.get_opatch_xslt) from dual;
ERROR:
ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 704
ORA-06512: at "SYS.DBMS_QOPATCH", line 1002
ORA-06512: at line 1

no rows selected


Read more...

Environment

  • UNIX / Linux
  • SAP Release Independent
  • As of Oracle RDBMS 12c

Keywords

DBMS_QOPATCH, oracle, 12.1, ORA-20001, ORA-06512, datapatch, SBP, SAP Bundle Patch, package, error, fail, select, dual, exec , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.