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

    oracle form 6i list item

    niceali
      hello
      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
      and
      if listitem is letter only those docname which names starting word letter should display

      i use this
           begin
           set_block_property('FILE_REF',default_where,
      'fileno ='||chr(39)||:emp.fileno||chr(39)||'and docname='||chr(39)||:file_ref.list_item1||chr(39));
      go_block('FILE_REF ');
           execute_query;
           end;

      and a error generated
      bad bind variable

      can anyone help pls