Home » SQL & PL/SQL » SQL & PL/SQL » concurrency with ORA_ROWSCN (oracle 11g express edition and .net 2005)
concurrency with ORA_ROWSCN [message #560990] Wed, 18 July 2012 03:08 Go to next message
Messages: 16
Registered: July 2012
Junior Member
Dear Sir/Madam and friends

can i use ORA_ROWSCN to handle concurrency in oracle,
That is i want to read ora_rowscn and keep it in my form or BL then before update i want to read ora_rowscn and match with old version.

1)Since it is updated after commit , how can it affect the application?
2) should i use some Guid in place of ORA_ROWSCN?
3) sequence in each table with trigger in place of ORA_ROWSCN?

yours sincerely
Re: concurrency with ORA_ROWSCN [message #560994 is a reply to message #560990] Wed, 18 July 2012 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you can use ORA_ROWSCN but you first have created the table with the ROWDEPENDENCIES option.

Re: concurrency with ORA_ROWSCN [message #560995 is a reply to message #560990] Wed, 18 July 2012 03:20 Go to previous message
Messages: 159
Registered: February 2008
Location: Reims
Senior Member
It's Ok if yours segments are created with ROWDEPENDECIES enabled. But usually that's not the default case.
Previous Topic: Trigger
Next Topic: Package & Procedure
Goto Forum:

Current Time: Fri Jul 21 20:18:18 CDT 2017

Total time taken to generate the page: 0.17531 seconds