Code Listing 2: Hard-coding a SQL query (and business rules) 

 1  CREATE OR REPLACE PROCEDURE process_employee (
 2     employee_id_in IN NUMBER)
 3  IS
 4     l_name VARCHAR2(100);
 5  BEGIN
 6     SELECT last_name || ',' ||
 7            first_name
 8       INTO l_name
 9       FROM employee
10      WHERE employee_id = employee_id_in;
11
12      perform_detailed_analysis (
13         l_name);
14  END;