DBMS_SQL package
uPredecessor
of native dynamic SQL
uPros:
ØGoes
above 32K
ØSeparates
PARSE and EXECUTE
§The
same query can be reused with different bind variables.
ØWorks
with unknown number/type of INPUT/OUTPUT values
uCons:
ØSignificantly
slower (up to 5 times)
ØNo
user-defined datatypes or output to the record
ØMore
difficult to use
uConclusion:
Should be avoided unless really needed
