I 'm developting a Project using Oracle9i Form. Now I have a ploblem that I ca'nt solve. That is:
- When I go to a record in Form and change data. But if this record is locking by other transaction I alway get a alert look like "Could not reserve 2 tries. Keep trying ?".
Can you show me the sollution to hide this alert or I can replace this message by Vietnamese ?.
I really need the sollution for this Ploblem. Help me, please !
I can give you the PL/SQL to check and lock a row - you'll have to work out how to integrate it into your forms code...
function CheckAndLock( inID in tablename.pk%type ) is
where pk = inID
for update nowait;
return (1); -- locked successfully
exception when others
-- Already locked or some other error