Getting PLS-457 with Dynamic SQL in 10g

PLS-00457: in USING clause, expressions have to be of SQL types
EXECUTE IMMEDIATE

Datatypes of bind and define variables are any that are permitted in SQL

NULL is not valid data type for nullable column