don't use execute immediate, use dbms_sql with the overloaded version that allows you to use varchar2s array to supply sql. Raj -- //www.freelists.org/webpage/oracle-l