About locking, if we manage an XML document stored in a CLOB or a BLOB, can anyone access the same XML document?
Just like any other CLOB, if someone is writing to the CLOB, they have it locked and nobody else can write to the CLOB. Other users can read it, but not write to it. This is basic LOB behavior. An alternative is to decompose the XML document and store the information in relational fields. Then you can modify individual elements, have element-level simultaneous access, and so on. In this case, using something called the USER_DATASTORE and PL/SQL, you can reconstitute the document to XML for text indexing. Then, you can search the text as if it were XML, but manage the data as if it were relational data. Again, see the Oracle Text Technical Overview for more information at: http://otn.oracle.com/products/text.
Related Questions
- I know that an intact XML document can be stored in a CLOB in Oracles XML solution. Can XML documents stored in a CLOB or a BLOB be queried like table schema?
- String to XMLDocument I have an xml document stored in a String variable. How do I take the String and parse it into an XMLDocument?
- About locking, if we manage an XML document stored in a CLOB or a BLOB, can anyone access the same XML document?