Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

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

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

0
wxII
Asked:
wxII
  • 2
1 Solution
 
sdstuberCommented:
for oracle, it's just another column, even if the underlying structure is object relational,  the "main" table has a single column in a single row.  All locking/isolation issues are handled at that layer.
0
 
sdstuberCommented:
If you needed further assistance you just needed to ask.  Please do not assign penalties without giving the volunteers (not just me) a chance
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now