SQL & PL/SQL

Hi Experts,

I have a doubt regarding Dynamic queries & 'Execute Immediate'.

Scenario -
Suppose, I've an Insert statement and it has some string-aggregation being used.

Fyi - we used Tom Kytes 'STRAGG(distinct ...)' technique for aggregation.

Now if I put this INSERT stat inside my proc NOT as a Dynamic query, it throws err.
So, i had to put Execute Immediate.

Doubt -
Does performance gets affected if a SQL query is changed to Dynamic and then executed (using Execute Immediate) ??

Thanks in Advance.
Ranit B.

Database version -- 10.0