6 Replies Latest reply: Jan 23, 2014 12:40 AM by AnnPricks E RSS

    cursor for loop in  oracle forms 6i

    994122

      Hi all,

       

             I have written code in the find button to display deptno=10 employees ,in TOAD it worked fine, but why it is not worked in the form find button? Please suggest? I added below i am getting all records? , I want only related employees records..

       

      BEGIN

          FOR e_cursor  IN ( SELECT ename  FROM emp where deptno=10 ) LOOP

            dbms_output.put_line( e_cursor.ename );

          END LOOP;

          --EXECUTE_QUERY;

      END;

       

      Thank You