I am executing below procedure through TOAD and getting the compilation error. I have also tried to execute through direct DB connection but getting same error.
================================
PLS-00201: identifier 'XMLGEN.RESETOPTIONS' must be declared
PL/SQL: Statement ignored
PL/SQL: Statement ignored
PLS-00201: identifier 'XMLGEN.INSERTXML' must be declared
=======================================
CREATE OR REPLACE PROCEDURE loadxml1 AS
fil clob;
buffer varchar2(1000);
len INTEGER;
insrow INTEGER;
BEGIN
SELECT c_s_xml INTO fil FROM xmlstore ;
len := DBMS_LOB.GETLENGTH(fil);
DBMS_OUTPUT.PUT_LINE('length '||len);
DBMS_LOB.READ(fil,len,1,buffer);
xmlgen.resetOptions;
insrow := xmlgen.insertXML('xml_doc',buffer);
DBMS_OUTPUT.PUT_LINE('length ins '||insrow);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('In Exception');
DBMS_OUTPUT.PUT_LINE(SQLERRM(SQLCODE));
end;
Also please find below the output of components installed in my db instance.
SQL> SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
COMP_NAME||':'||VERSION||':'||STATUS
--------------------------------------------------------------------------------
Oracle Database Catalog Views : 12.2.0.1.0 : VALID
Oracle Database Packages and Types : 12.2.0.1.0 : VALID
JServer JAVA Virtual Machine : 12.2.0.1.0 : VALID
Oracle XDK : 12.2.0.1.0 : VALID
Oracle Database Java Packages : 12.2.0.1.0 : VALID
OLAP Analytic Workspace : 12.2.0.1.0 : VALID
Oracle Real Application Clusters : 12.2.0.1.0 : OPTION OFF
Oracle XML Database : 12.2.0.1.0 : VALID
Oracle Workspace Manager : 12.2.0.1.0 : VALID
Oracle Text : 12.2.0.1.0 : VALID
Oracle Multimedia : 12.2.0.1.0 : VALID
COMP_NAME||':'||VERSION||':'||STATUS
--------------------------------------------------------------------------------
Spatial : 12.2.0.1.0 : VALID
Oracle OLAP API : 12.2.0.1.0 : VALID
Oracle Label Security : 12.2.0.1.0 : VALID
Oracle Database Vault : 12.2.0.1.0 : VALID