HELP WITH DYNAMIC SQL (DBMS_SQL PACKAGE)

I am trying to create a query with the DBMS_SQL package. Basically I = have to update about 85 tables with a country code... My problem is that = there are about three different name for the country code(i.e. = country_cde, country_code, country)
and even more for the state which I base the query on. the problem is = when I try to parse this statement I get an error

DBMS_SQL.PARSE(datCur, 'select COLUMN_NAME from all_tab_columns where column_name LIKE ' ' '%COUNTRY%' ' ' AND TABLE_NAME= '|| datTableName,DBMS_SQL.NATIVE);

datTableName is passed into the program from UTL_FILE.getline  

Dan White
Oracle Programmer/Analyst
dwhite_at_mail.intracorp.com Received on Wed Dec 01 1999 - 19:21:45 CST