Oracle PL/SQL - Reusing bind variables

Introduction

PL/SQL can reuse the same bind variable in Dynamic PL/SQL

Demo

SQL>
SQL> declare-- www .  j a v a  2  s.com
  2       a NUMBER:=2;
  3       b NUMBER:=3;
  4       v_plsql_tx VARCHAR2(2000);
  5  begin
  6      v_plsql_tx =
  7      'BEGIN ' ||
  8       '    :1 := :1*:2; ' ||
  9      'END;';
 10      execute immediate v_plsql_tx
 11      using in out a, b;
 12      DBMS_OUTPUT.put_line('a='||a);
 13  end;
 14  /
SQL>

Related Topic