Toad World® Forums

help to solve ,plsql not execute


#1

help to solve ,plsql not execute


#2

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