CREATE OR REPLACE PROCEDURE get_dept (p_deptno IN VARCHAR2, p_dname OUT VARCHAR2, p_loc OUT VARCHAR2)IS l_rate NUMBE
