var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Native Dynamic SQL to DBMS_SQL Package
Can we switch from Native Dynamic SQL to DBMS_SQL Package and if yes how??
Like if I want to use a cursor created in Dynamic SQL how it can be used with DBMS_SQL packages??
In Oracle 11G you can switch between NDS and DNMS_SQL - see Oracle 11G PL/SQL documentation.
When you need both the DBMS_SQL package and native dynamic SQL, you can switch between them, using the "DBMS_SQL.TO_REFCURSOR Function" and "DBMS_SQL.TO_CURSOR_NUMBER Function".