Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011

    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??

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1
    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".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts