CURSOR Problem [message #908] |
Tue, 12 March 2002 04:25 |
Jeremy Stillman
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
I wonder if anybody can offer me any advise on a problem I'm having with a cursor I'm trying to write (first attempt!).
The cursor is as follows;
declare
cursor hf_code is
select /*c.uin,*/ c.hf2_up
from ross_query.cfe c, unit_link u
where c.uin = u.uin
for update of c.hf2_up nowait;
begin
for unit_record in hf_code loop
update unit_link
set unit_link.hfadm = unit_record.hf2_up
where current of hf_code;
end loop;
commit;
end;
/
When I trying running the cursor in SQL*Plus I keep getting the Oracle message
ERROR at line 1:
ORA-08103: object no longer exists
ORA-06512: at line 9
When I check the database the table (unit_link) is still there! If anybody can help I would be extremely grateful
Many Thanks
Jel Stillman
|
|
|
Re: CURSOR Problem [message #909 is a reply to message #908] |
Tue, 12 March 2002 04:41 |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
I believe some body might have deleted your object. Try to write full code of your procedure. You need a procedure name to run this query.
HTH
Ravi
|
|
|
Re: CURSOR Problem [message #3285 is a reply to message #908] |
Tue, 17 September 2002 10:55 |
Jeeju
Messages: 1 Registered: September 2002
|
Junior Member |
|
|
Stillman,
Can you check while ur running this script, is there any othere proces which is doing a truncate to any of the tables you refer ? if so, that could be the problem. Thought it not suppose to happen, could come across lots of bug like this. Also which version r u using and what plantform ?
I came across this in 8.1.7.0 to 8.1.7.4 on NT.
Jeeju
|
|
|