Something, somewhere is doing an implicit conversion. Since int has a higher precedence than varchar the string "www.com" is being cast to int and failing.
First try a simple select * from view_a. Does that succeed? If it does it suggest table1 and table2 have compatible data types in their corresponding columns.
Second check the types assigned to ...
Slightly rewritten (so that number of rows is fetched out of the cursor):
SQL> create or replace procedure find_table_with_column_value
2 (arg_column_name in varchar2, arg_column_value in varchar2)
4 v_rowcount number;
5 v_sql_statement varchar2(4000);
7 for l in (select owner || '.' || table_name as owner_table
Specifying a value after INT (e.g. INT(8)) does nothing in MySQL apart from affecting the ZEROFILL option. From here (the poster has ~ 500K rep. on StackOverflow and was MySQL Community Manager, so he probably knows what he's talking about):
The 20 in INT(20) and BIGINT(20) means almost nothing. It's a hint for
display width. It has nothing to do with ...