i can not run my procedure.... i do not why.......

there my procedure and test code:

CREATE OR REPLACE PROCEDURE make_reservation( a_s_date IN DATE, a_e_date IN DATE, a_c_id IN VARCHAR2, a_v_id IN VARCHAR2, a_e_budget IN NUMBER, p_res_id OUT VARCHAR2 ) IS l_res_id CHAR(20); l_dob DATE; BEGIN SELECT dob INTO l_dob FROM client WHERE c_id = a_c_id; BEGIN SELECT dob INTO l_dob FROM client WHERE c_id = a_c_id; EXCEPTION WHEN NO_DATA_FOUND THEN RAISE_APPLICATION_ERROR(-20001, 'Client ID does not exist'); END;

IF MONTHS_BETWEEN(SYSDATE, l_dob)

SELECT NVL(MAX(res_id), 0) + 1 INTO l_res_id FROM reservations; INSERT INTO reservations (res_id, s_date, e_date, c_id, v_id, t_cost) VALUES (l_res_id, a_s_date, NULL, TO_NUMBER(a_c_id), TO_NUMBER(a_v_id), a_e_budget * (a_e_date - a_s_date + 1));

p_res_id := l_res_id;

DBMS_OUTPUT.PUT_LINE('Reservations registered successfully with id ' || l_res_id); END;

DECLARE l_res_id VARCHAR2(20); BEGIN make_reservation( a_s_date => TO_DATE('2003-09-08', 'YYYY-MM-DD'), a_e_date => TO_DATE('2003-09-12', 'YYYY-MM-DD'), a_c_id => 't07098', a_v_id => 'V09', a_e_budget => 100, p_res_id => l_res_id ); END;

where is my code errors?.........

ORA-01403: no data found ORA-06512: at "SQL_XWQHXYSMRYZNUHWSQLMADCTLY.MAKE_RESERVATION", IIne 13 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SQL", line 1721