execute immediate is an 8.1 feature. It looks like you are running 8.0.x? If so, you have to use the clunky DBMS_SQL package. ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_sql.htm#998100[/url] )