From Tom Kyte if you are going to parse the same statement many times.... And you are not using a version that allows for bulk binds in native dynamic sql (bulk binds offsets the parse issue)..... http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/11_dynam.htm#16379 then DBMS_SQL (using the array interface as well!) can be more efficient yes. If you have "Expert One on One Oracle", I cover this from a performance perspective in the Dynamic SQL chapter. Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------