You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Register XML Schema

Received Response
6
Views
1
Comments
edited Apr 16, 2022 7:54AM in Autonomous Database 1 comment

Summary

Is DBMS_XMLSCHEMA available in Autonomous Database?

Content

Hi,

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&quot

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!