Home » Developer & Programmer » Forms » WHERE CURRENT OF
WHERE CURRENT OF [message #324518] Mon, 02 June 2008 23:27 Go to next message
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 !
Re: WHERE CURRENT OF [message #324645 is a reply to message #324518] Tue, 03 June 2008 08:37 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

If you are using 'commit' then try with commit_form instead of commit.
Re: WHERE CURRENT OF [message #325207 is a reply to message #324518] Thu, 05 June 2008 05:15 Go to previous messageGo to next message
raywong9i
Messages: 40
Registered: April 2008
Member
I am using commit_form already. Embarassed
Re: WHERE CURRENT OF [message #335389 is a reply to message #325207] Tue, 22 July 2008 01:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use 'standard.commit'.

David
Previous Topic: GROUP BY BLOCK ON FORM
Next Topic: How to populate roles
Goto Forum:
  


Current Time: Mon Dec 05 08:40:57 CST 2016

Total time taken to generate the page: 0.10197 seconds