1 Reply Latest reply: Oct 18, 2012 3:39 AM by odie_63 RSS

    Parse schema data in table column

    928885
      Hi,

      I have a XSD and XML data in table column and want to validate. But i am not supposed to use the registerSchema methods since there are lot of XSD files and these will be changed very frequently.

      1. So i am trying to manually parse through the XSD and XML files to validate. Is there a good approach other than this?
      2. How to parse the XSD file in oracle

      Thanks in advance,
      Vinod
        • 1. Re: Parse schema data in table column
          odie_63
          Hi Vinod,
          1. So i am trying to manually parse through the XSD and XML files to validate.
          So you're trying to reinvent the wheel?
          Good luck! :)
          Is there a good approach other than this?
          If you want to use the built-in validation features then there's no way around registering the schema using DBMS_XMLSCHEMA.registerSchema.
          But i am not supposed to use the registerSchema methods since there are lot of XSD files and these will be changed very frequently.
          How much is "a lot", and "frequently"?

          If your XML schemas change so frequently, I guess you have to rethink the approach and use either a Java stored procedure to perform the validation (it can be called from PL/SQL) or a 3rd party tool.