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: 65146
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: 21148
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: Unattended Installation of 10G
Next Topic: SQL Developer hangs
Goto Forum:

Current Time: Mon Aug 21 09:07:29 CDT 2017

Total time taken to generate the page: 0.00923 seconds