如何生成:NEW dynamic PL/SQL

DECLARE
  sql_stmt VARCHAR2(200);
  result NUMBER;
BEGIN
  sql_stmt := 'SELECT COUNT(*) FROM employees WHERE department_id = :dept_id';
  EXECUTE IMMEDIATE sql_stmt INTO result USING 10;
  DBMS_OUTPUT.PUT_LINE('Number of employees in department 10: ' || result);
END;

DECLARE
  cur_id INTEGER;
  sql_stmt VARCHAR2(200);
  result NUMBER;
BEGIN
  sql_stmt := 'SELECT COUNT(*) FROM employees WHERE department_id = :dept_id';
  cur_id := DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(cur_id, sql_stmt, DBMS_SQL.NATIVE);
  DBMS_SQL.BIND_VARIABLE(cur_id, ':dept_id', 10);
  DBMS_SQL.DEFINE_COLUMN(cur_id, 1, result);
  DBMS_SQL.EXECUTE(cur_id);
  IF DBMS_SQL.FETCH_ROWS(cur_id) > 0 THEN
    DBMS_SQL.COLUMN_VALUE(cur_id, 1, result);
    DBMS_OUTPUT.PUT_LINE('Number of employees in department 10: ' || result);
  END IF;
  DBMS_SQL.CLOSE_CURSOR(cur_id);
END;