Record blocking

[astenax]

Hello, all!

I want permit access to any record in database only for one session and blocking this record for other session. I use expression:

create or replace procedure ....
(input/output parameters)
begin

select
balance
into
card_balance
from
xcard
for
update nowait;

any action.....
end;

This stored procedure I called from Perl's script and not get block action in procedure.

It is correct way?

[tamilselvan]

Do you want serialized transactions?

Tamil

[astenax]

Originally posted by tamilselvan
Do you want serialized transactions?

Tamil

It is an approximate equivalent action?