Lock a table row while reading it
Posted: Tue Oct 19, 2004 10:18 am
Hi All,
I have an Oracle table A that has only one row.
I have the following requirement:
1) Read table A and get the value of J_ID from it.
2) Increment the value by 1 and update it back to J_ID in table A.
Now, I want the moment I read the J_ID value from the table the row should get locked and no other process should be able to read the value until I update the incremented value back into the table.
Is there any way I can do a row lock OR table lock on table A from DataStage?
Thanks and Regards,
-Sumit
I have an Oracle table A that has only one row.
I have the following requirement:
1) Read table A and get the value of J_ID from it.
2) Increment the value by 1 and update it back to J_ID in table A.
Now, I want the moment I read the J_ID value from the table the row should get locked and no other process should be able to read the value until I update the incremented value back into the table.
Is there any way I can do a row lock OR table lock on table A from DataStage?
Thanks and Regards,
-Sumit