1 2 Previous Next 18 Replies Latest reply: Jan 25, 2013 3:53 AM by 967903 RSS

    error unable to resolve reference to items.

    967903
      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