IF dbms_xmldom.getlength(nodeList) = 0 THEN
NodeList := dbms_xmldom.getchildrenbytagname(mydocElement, 'PROCESS_QUEUE') MydocNode := dbms_xmldom.appendChild(xmlNode, dbms_xmldom.makeNode(mydocElement)) MydocElement := dbms_xmldom.createElement(xmlDocument, 'MYDOC') XmlNode := dbms_xmldom.makeNode(xmlDocument)
XmlDocument := dbms_xmldom.newDOMDocument XmlDocument := dbms_xmldom.newDOMDocument(xmlParams) MydocNode := dbms_xmldom.makeNode(mydocElement) MydocElement := dbms_xmldom.getdocumentelement(xmlDocument) IF NOT dbms_xmldom.isnull(xmlDocument) THEN XmlDocument IN OUT NOCOPY dbms_xmldom.DOMDocument
Create the DBMS_XMLDOM schema in PostgreSQL:. PrerequisitesĪssuming that you have an Oracle and a PostgreSQL databases up and running, proceed with the following steps.īefore getting started, you have to create several database objects in PostgreSQL: Therefore, make sure to complete a thorough assessment of the database and its dependent applications before proceeding with this solution and make sure there are no objections or concerns to using the JSON data type. This solution uses the JSON data type instead of XML to convert Oracle’s DBMS_XMLDOM package to PostgreSQL. PLV8 is a trusted JavaScript language extension for PostgreSQL that you can use for stored procedures, triggers, and more. In this solution, we create the DBMS_XMLDOM schema and wrapper package functions equivalent to Oracle in a PostgreSQL database using the PLV8 extension. The DBMS_XMLDOM package in Oracle is used to access XML type objects and implements the Document Object Model (DOM), an application programming interface for HTML and XML documents. We chose JSON because JSON is the native format for data in JavaScript, and PostgreSQL has extensive support of JSON compared to XML. In this post, we discuss a solution that uses the JSON data type instead of XML to migrate stored procedures from Oracle to PostgreSQL and reduce migration efforts. Moreover, converting procedures to Aurora PostgreSQL or Amazon RDS for PostgreSQL could be a cumbersome and time-consuming process depending on the amount of stored procedures dependent on the DBMS_XMLDOM package. This is because the DBMS_XMLDOM package isn’t supported in Aurora PostgreSQL or Amazon RDS for PostgreSQL. Migrating from Oracle to Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL may be challenging if the application is using the DBMS_XMLDOM package to access XML type objects.
0 kommentar(er)
