This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 25, 2013 1:53 AM by 967903 RSS

error unable to resolve reference to items.

967903 Newbie
Currently Being Moderated
hello experts,
i have a problem in oracle form.i have to search item that are coming thorugh db. a same items comes multiple time.
suppose a item XXX comes five times in form then when i search for this item XXX then cursor search this part five times one by one

i using below code for searching.then that error comes unable to resolve reference to items.pls help me to resolve this issue.

DECLARE
temp_last number(2);
item varchar2(30);
chk_exc exception;
i number(2);
j number(2);

BEGIN
go_block('BLOCK3');
last_record;
temp_last:=to_number(:system.cursor_record);
for i in 1..temp_last
loop
go_record(i);
item:=:BLOCK3.item;
if ITEM=:BLOCK1.SEARCH_PART
THEN
GO_ITEM(':BLOCK3.item');
end if;
end loop;
exception
when chk_exc then
mess(' Not Exist !');
Raise form_trigger_failure;
END;

Thanks
Ravi
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points