News

Bind variables can be used in almost any place in PL/SQL with one exception: bind variables in anonymous PL/SQL blocks cannot appear in conditional compilation directives.
The key is that PL/SQL doesn't know anything about the bind variable when it is parsing and validating the PL/SQL that is about to execute -- so you have to use a local variable and copy the local ...