2 Replies Latest reply: Jul 8, 2013 7:09 PM by Cuauhtemoc Amox RSS

    Error in a search screen

    990187

      i have designed a search query screen with four fileds-empno,ename,hiredate1,hiredate2 . .if i enter some empno in empno field it has to retrieve all the emps belong to that number . .the same applies to remaining also . . in order to do this requirement i have tried a key next item on ename field . . just to see whether it works or not . . .

       

      declare

      cri varchar2(20);

      begin

      cri:='ename='||:block3.ename;

      set_block_property('emp',default_where,cri);

      go_block('emp');

      execute_query;

      end;

      there are no errors but when i enter the ename in field and run it is displaying as   FRM-40505: ORACLE error: unable to perform query.Can anyone rectify this.