6 Replies Latest reply on Jan 23, 2014 6:40 AM by AnnEdmund

    cursor for loop in  oracle forms 6i


      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..



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

            dbms_output.put_line( e_cursor.ename );

          END LOOP;




      Thank You