Hi, I have a script I've been using in an anonymous PL/SQL block that searches some tables for a string value. I want to change this so that it is a Stored Procedure where the user that calls the procedure can supply the table_owner info. FOR t IN (SELECT owner, table_name, column_name FROM all_tab_columns WHERE owner = 'BLAH' and data_type LIKE '%CHAR%') LOOP so can i substitute the 'BLAH' text for a variable as in .. DECLARE OWNER_VARIABLE NVARCHAR2; BEGIN FOR t IN (SELECT owner, table_name, column_name FROM all_tab_columns WHERE owner = OWNER_VARIABLE and data_type LIKE '%CHAR%') LOOP I have tried this but it doesn't work. I'm not sure of the syntax to substitute text for a variable in a for loop. Any help would be appreciated. Thanks, Rob.