Dynamic SQL Enhancements

This entry is part 4 of 8 in the series New Pl/Sql features 11g

Changes have been made to both Native Dynamic SQL (NDS) and the DBMS_SQL package:

Changes to NDS:

  • the 32k limit has been lifted; EXECUTE IMMEDIATE now allows CLOB values passed in
  • the 32k limit has been lifted; OPEN FORALL now allows CLOB values passed in

Changes to DBMS_SQL package:

  • the 32k limit has been lifted; The DBMS_SQL.PARSE is now overloaded for CLOB argument
  • New TO_REFCURSOR function; Allowing switching to NDS from DBMS_SQL
  • New TO_CURSOR_NUMBER function; Allowing switching to DBMS_SQL from NDS
  • All data types that native dynamic SQL supports are supported.
Series Navigation<< Sequences in PL/SQL ExpressionsUse named and mixed notation from SQL >>

Posted in Oracle, Pl/Sql Tagged with: , ,

Leave a Reply