Lock records or table

well, normal work, but I intend to do a select for update so that I can ensure an exclusive lock is encountered while operating on the data.

That's beyond my level of expertise. I am only able to do simple things.

But they work. Are normal insert or update queries not appropriate for your situation?

Dan,

I tried to use the select for update in one of the package fucntions, but it doesnot work. Do you have any idea?

Aruna

I just run the query and let oracle look after any locking that is required.

arunaumuc wrote:
> Please re- read to mean this:
>
> How do I lock records at back end when I am processing the records in CF. I want to lock the entire table for insert. I also want to lock a few rows for update.
>
>

I believe the <cftranaction...> tag allows one to tell the database how
you would like it to lock records.

Please re- read to mean this:

How do I lock records at back end when I am processing the records in CF. I want to lock the entire table for insert. I also want to lock a few rows for update.