Concurrency control, Locking on read,update,delete for xmltype columns
Posted on 2008-10-23
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