Oracle Lock

[Quoted] [Quoted] Hello, my name is Roman Kirillov. I have some Oracle issue and I need help. Our company used Microsoft SQL before, but about 8
months ago we switched to Oracle. Most of our code was transferred without any issues except this one. We used to do ROWLOCK in our SQL commands when writing ATL applications for accessing dbases, but with Oracle
it does not seem to be working. Do you know of any good way to lock the row in Oracle after or during selection that no one else can modify it, then update it. I really need to have it in some of my C++ applications (not letting anyone touch my row until I do update). There is has to be a way to make it part of SQL command.
I looked in documentation for Oracle, but did not find anything on row lock. Seems very strange because this issue is very important for any programmer.

I give an example how we used to do this in Microsoft SQL, could you please help on this issue with Oracle.

Example of Microsoft SQL row lock and update: SELECT mins.min_id, mins.min_num FROM mins WITH (ROWLOCK) WHERE (mins.status = 'F' OR mins.status = 'U') AND mins.lca_id = 'somenumber'                        

UPDATE mins WITH (ROWLOCK) SET status = 'A' WHERE min_id = 'someminid from previous select'

I would really appreciate any help. Thank you very much. Sincerely,
Roman.

-- 
********************************************


* Roman Kirillov                        

* Software Engineer               

* equitel, inc. 

* 4021 Stirrup Creek Drive, Suite 400    

* Durham, NC  27703                       

* Phone: (919) 419-5600  

* Direct:(919) 419-7758

* Fax:   (919) 419-5601

* mailto:rkirillov_at_equitel.com


* http://www.equitel.com


********************************************