Looks like we cannot use host variables in dynamic sql. But the whatever I am trying to achieve becomes difficult.
My requirement is below.
I want to update a table, but the columns of the table that need to updated is not fixed. i.e, for example this time I want to update only one coulmn of the table, but in a different situation I have to update 2 or 3 columns.