Is there a way to substitute object names as such table_name or view name with bind variables in the following sample code? obviously this code does not run because I cannot substitute :b1 with tabname.table_name. suggestions? create or replace procedure testbind (v_id in number) as begin for tabname in (select table_name from user_tables where table_name like 'TAB%') loop execute immediate 'delete :b1 where id=:b2' using tabname.table_name,v_id; end loop; end; / thanks. geraldine -- //www.freelists.org/webpage/oracle-l