help to solve ,plsql not execute
Hi
It may be due to a data not found error on the select statement.
If you add an exception handler you may be able to catch it.
Cheers
Rob
CREATE OR REPLACE PROCEDURE s
(p_id IN employee.EMPLOYEE_ID%TYPE,
P_name OUT employee.LAST_NAME%TYPE,
P_salary OUT employee.SALARY%TYPE,
P_comm OUT employee.COMMISSION_PCT%TYPE)
IS
BEGIN
select last_name,salary,commission_pct
into P_name,P_salary,P_comm
from employee
where EMPLOYEE_ID=P_id;
EXCEPTION
WHEN NO_DATA_FOUND
THEN DBMS_OUTPUT.PUT_LINE(‘EXCEPTION HANDLER’);
END;
Rob Silver
Marketing Analyst
HSDL
Trinity Road
Halifax
HX1 2RG