Forum Stats

  • 3,825,912 Users
  • 2,260,577 Discussions
  • 7,896,735 Comments

Discussions

Import UBL 2.1 xml

User_WWD0C
User_WWD0C Member Posts: 9 Green Ribbon

BEGIN

 DBMS_XMLSCHEMA.registerSchema(

    SCHEMAURL => 'https://docs.oasis-open.org/ubl/os-UBL-2.1/xsd/maindoc/UBL-Invoice-2.1.xsd',

  SCHEMADOC => bfilename('XMLDIR','/maindoc/UBL-Invoice-2.1.xsd')

);

END;

and i need to generate output based in UBL 2.1 invoice

any idea how to do it properly

Answers

  • Jason_(A_Non)
    Jason_(A_Non) Member Posts: 2,095 Silver Trophy

    As far as I know, you have to build the XML yourself via methods such as XMLElement, XMLForest, XMLAgg, etc. Oracle did not have any way to automatically transform the results of a query into XML based upon a registered schema.