Home » Infrastructure » Windows » dml locks
dml locks [message #293198] Fri, 11 January 2008 03:29 Go to next message
hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai
Member
How to call same function from multiple PCs simultaneously.
This function has insert statement.
Thanks in advance......

Hari

Report message to a moderator

Re: dml locks [message #293216 is a reply to message #293198] Fri, 11 January 2008 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't think this is an Oracle issue and I don't see the relation with DML locks.

Regards
Michel

[Updated on: Fri, 11 January 2008 04:01]

Report message to a moderator

Re: dml locks [message #293238 is a reply to message #293198] Fri, 11 January 2008 05:22 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What prevents you to run this "function"? Do you want to simulate a multi-user environment, or will it be executed by "real" users (people who actually sit behind these PC's and do something, which involves using your "function")?

Why do you expect locks of any kind? Who will lock who? INSERTS don't lock the table. There might be a problem of violating unique key constraints, though. It will cause a lock until a first user commits, and then the locked one(s) will get a message about unique constraint violation.

So, could you explain your problem a little bit more?

Report message to a moderator

Previous Topic: Manually create a second Oracle 10g database in Windows
Next Topic: Basic PC Requirement to run Oracle 11i <Oracle Applications Version : 11.5.10.1> (e-Business S
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 08:49:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.