4 Replies Latest reply: Dec 6, 2012 11:15 PM by Billy~Verreynne RSS

    PL/SQL code for a search button

    978480
      i'm trying to write a PL/SQL for a search button , like in this picture

      http://uppix.net/f/7/1/484994cbbb235d7041484588c2463.jpg

      i tried this

      begin
      SELECT employee_id , first_name , last_name , manager_id , department_id
      into
      :employee_id , :first_name , :last_name , :manager_id , :department_id

      FROM EMPLOYEES WHERE :DEP_ID = :DEPARTMENT_ID;
      end;


      but it didn't work

      hope someone can help
      thanks.