For optimal scalability, you really need to use DBMS_SQL. Execute immediate, even if properly implemented w/ binds, will do extra soft parsing. Only w/ DBMS_SQL can you get the optimal parse once, execute many behavior. -Mark -----Original Message----- From: Juan Cachito Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx] Sent: Tue 3/30/2004 7:50 AM To: oracle-l@xxxxxxxxxxxxx Cc: Subject: Re: bind variables & dbms_sql in procedure/packages Whenever is possible I prefer to use execute immediate, it allows binding, and is easier to use and to check. 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 -----------------------------------------------------------------