DECLARE l_row dept%ROWTYPE; BEGIN l_row := dept_api.get(p_dname => 'Accounts'); /* Do something with the value you have retrieved in l_row */ END;