Inside a stored package i am using SELECT........FOR UPDATE statement.
On certain occassions(Not always) it throws out a -54 error,but no other sessions are accessing the same resource(table). Only one form calls this package.
When i logout and login again this error is not raised again. but within the same session if i retry same error occurs again

When this error occurs,querying the Data dictionary with the following statement returns no rows

SELECT XIDUSN,SESSION_ID,OBJECT_NAME,OS_USER_NAME FROM V$LOCKED_OBJECT A,DBA_OBJECTS B
WHERE A.OBJECT_ID=B.OBJECT_ID;

Database server version 8.1.5.0.0 (workgroup)
Operating system Windows NT 4.0 server
Front end applications Oracle D2K Forms/Reports ver 6.0

How can i overcome this problem?