OraFAQ Forum: Forms » WHERE CURRENT OF

Home » Developer & Programmer » Forms » WHERE CURRENT OF

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

WHERE CURRENT OF [message #324518]

Mon, 02 June 2008 23:27

raywong9i
Messages: 40
Registered: April 2008

Member

Hi all,

I have encounter a strange problem. Currently, I am doing the migration of 6i forms to 10g version. I have found that some of my forms which make use of the "WHERE CURRENT OF" statement will not work occassionally. Shocked

The coding are like this :
-----------------------
cursor cur_1(pi_status varchar2) is
select * from table_a
where status = pi_status
for update of status;
----------------------
For i in cur_1 ('A') loop
update table_a
set trmn_dt = sysdate
where current of cur_1;
END FOR;
----------------------

The problem is when I first login the system, the update statment
can be work and committed perfectly, but if I continue to use the same function, the update statement cannot work, the record
cannot be updated.

But if I logout the system and relogin, then it works.

I try to use rowid instead of "where current of", and it works perfectly.

Just wondering is it a known problem from 10g ????

Thanks !

Report message to a moderator