Home » Infrastructure » Windows » dml locks
dml locks [message #293198] Fri, 11 January 2008 03:29 Go to next message
Messages: 65
Registered: November 2006
Location: Mumbai

How to call same function from multiple PCs simultaneously.
This function has insert statement.
Thanks in advance......

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: 68165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think this is an Oracle issue and I don't see the relation with DML locks.


[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
Messages: 21714
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?
Previous Topic: Manually create a second Oracle 10g database in Windows
Next Topic: Basic PC Requirement to run Oracle 11i <Oracle Applications Version :> (e-Business S
Goto Forum:

Current Time: Wed May 18 18:17:09 CDT 2022