Row Locking
Hi Expertees,
I executed the query like below
SELECT ATTRIBUTEIDHINT FROM GLOBALPROPERTIES FOR UPDATE
and
UPDATE GLOBALPROPERTIES SET ATTRIBUTEIDHINT=100;
i did not commited or rollbacked and unfortunatly the application is closed .
Next time when i come to the same statement
SELECT ATTRIBUTEIDHINT FROM GLOBALPROPERTIES FOR UPDATE
and
UPDATE GLOBALPROPERTIES SET ATTRIBUTEIDHINT=100;
System is hanging it is not proceding further....
how to solve this one???
Thanks &Regards
Venkata Vara Prasad Kosaraju
Venkata vara Prasad Kosaraju