Hi Francois,<br />
great article! Just a suggestion for the procedure ins_upd_emp_dept in 2.3.1. Use a<br />
UPDATE DEPTSET DNAME = :EMP_DEPT.DNAMEWHERE DEPTNO = :EMP_DEPT.DEPTNO ;<br />
IF SQL%ROWCOUNT = 0 THEN -- record doesn't not exist INSERT INTO DEPT ( DEPTNO, DNAME ) VALUES ( :EMP_DEPT.DEPTNO, :EMP_DEPT.DNAME ) ;END IF;<br />
instead, makes the code more readable.<br />
Also keep up the good work with your PJC store!Patrick