execute-immediate - w3toppers.com

Using bind variables with dynamic SELECT INTO clause in PL/SQL

In my opinion, a dynamic PL/SQL block is somewhat obscure. While is very flexible, is also hard to tune, hard to debug and hard to figure out what’s up. My vote goes to your first option, EXECUTE IMMEDIATE v_query_str INTO v_num_of_employees USING p_job; Both uses bind variables, but first, for me, is more redeable and … Read more

Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?

Bind variables are not allowed in DDL statements. So following statements will cause errors: Example #1: DDL statement. Will cause ORA-01027: bind variables not allowed for data definition operations EXECUTE IMMEDIATE ‘CREATE TABLE dummy_table ( dummy_column NUMBER DEFAULT :def_val )’ USING 42; Example #2: DDL statement. Will cause ORA-00904: : invalid identifier EXECUTE IMMEDIATE ‘CREATE … Read more