Assign date with DBMS_SQL package : DBMS_SQL « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. DBMS_SQL

SQL>
SQL>
SQL> CREATE OR REPLACE PROCEDURE AssignDate (expr_in IN DATE, var_inout IN OUT DATE)
  2  IS
  3     cur PLS_INTEGER := DBMS_SQL.OPEN_CURSOR;
  4     returnValue PLS_INTEGER;
  5  BEGIN
  6     DBMS_SQL.PARSE (cur, 'BEGIN :var := :dtval; END;', DBMS_SQL.NATIVE);
  7     DBMS_SQL.BIND_VARIABLE (cur, 'var', SYSDATE);
  8     DBMS_SQL.BIND_VARIABLE (cur, 'dtval', expr_in);
  9     returnValue := DBMS_SQL.EXECUTE (cur);
 10     DBMS_SQL.VARIABLE_VALUE (cur, 'var', var_inout);
 11  END;
 12  /

Procedure created.

SQL>