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
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: 59425
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.

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: 19697
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 : 11.5.10.1> (e-Business S
Goto Forum:
  


Current Time: Fri Oct 24 08:16:04 CDT 2014

Total time taken to generate the page: 0.14509 seconds