Record level watches in Oracle
IT & Infrastructure
1
Posts
1
Posters
0
Views
1
Watching
-
Hello! I would like to discuss about setting record level watches in an oracle database. Also about locks in Oracle. My application needs to know when a record changes and should be posted with the changed value. Oledb has a way to do this ? Is Oledb recommended? Does it add extra weight to my app? and is it reliable? Regarding locks, I know i can set record level locks using select for update. But wheneve a commit or abort is called, the locks are freed. So, i would want to know about a way to lock and keep the key regardless of commits or rollbacks. does oci help? Will it help using Objects and ObjectPins? Thanks in advance. PGP