Hi

Why is that you opted for dynamic sql just for the reason to add a parameter.

Actually dynamic sqls creates the execution plan for every execution.