OraFAQ Forum: Windows

Home » Infrastructure » Windows » dml locks

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dml locks [message #293198]

Fri, 11 January 2008 03:29

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

Michel Cadot
Messages: 68641
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

Littlefoot
Messages: 21807
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:23:48 CDT 2024