1 Reply Latest reply on Apr 25, 2013 7:55 PM by Christian.Shay -Oracle

    oracle form 6i list item

      can anyone help i am using oracle form 6i. two tables emp and file_ref. in my emp block i have file no as text item. and from file_ref i have docname. i want to take a list item in which all and letter
      if listitem is all then all docname displayed
      if listitem is letter only those docname which names starting word letter should display

      i use this
      'fileno ='||chr(39)||:emp.fileno||chr(39)||'and docname='||chr(39)||:file_ref.list_item1||chr(39));
      go_block('FILE_REF ');

      and a error generated
      bad bind variable

      can anyone help pls