Register XML Schema
SummaryIs DBMS_XMLSCHEMA available in Autonomous Database?
I hope you are all well.
I am trying to register an XML XSD within my autonomous database, but I'm getting the following error (connected as ADMIN).
PLS-00201: identifier 'DBMS_XMLSCHEMA.REGISTERSCHEMA' must be declared
The code I'm running is detailed below.
I can't see anywhere in the 19c documentation, that this package isn't available in the Autonomous Database. If this feature isn't available, are there other alternatives?
DECLARE l_schema CLOB; BEGIN l_schema := '<?xml version="1.0" encoding="UTF-8"?> <xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ContactInfo"