<div>
If you needed further assistance you just needed to ask. &nbsp;Please do not assign penalties without giving the volunteers (not just me) a chance
</div>


If you needed further assistance you just needed to ask.  Please do not assign penalties without giving the volunteers (not just me) a chance

<div>
<div class="content wysiwyg-content">
hi all,<br />
<br />
i'm wondering whether the access of xmltype column data has any concurrency locking mechanism like ATOM? mostly i'm worried is the Isolation part upon reading the xml type data. <br />
<br />
eg. if reading, update,deleting particular node on xml, is there any locking pattern like READ COMMITED, SERIALIZED etc. accessing this information would be in stored programs only so it's constraint to PL/SQL environment.<br />
<br />
anyone has details on this and please advise and educate me, thanks<br />
<br />

</div>
</div>


hi all,

i'm wondering whether the access of xmltype column data has any concurrency locking mechanism like ATOM? mostly i'm worried is the Isolation part upon reading the xml type data. 

eg. if reading, update,deleting particular node on xml, is there any locking pattern like READ COMMITED, SERIALIZED etc. accessing this information would be in stored programs only so it's constraint to PL/SQL environment.

anyone has details on this and please advise and educate me, thanks



Concurrency control, Locking on read,update,delete for xmltype columns

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.