PL/SQL makes it very easy to execute dynamic SQL statements, including DDL and PL/SQL blocks, through either: Native Dynamic SQL EXECUTE IMMEDIATE OPEN FOR and DBMS_SQL, a comprehensive supplied ...

When I execute a dynamic SQL statement, I must have an expression in the USING clause for each placeholder - by position, not name. So you see three variables, including val_in twice. Of course, I ...

Even in Oracle 10g, there is no such command. I've been watching native dynamic SQL for a long time, and I still find that it's not as powerful as DBMS_SQL in these cases.