Execute Immediate VS Dynamic SQL (DBMS_SQL)

[eeriehunk]

Hi All,
I was going through DBMS_SQL package when I tried to research on Dynamic SQL. I couldn't understand the necessity for this package since we can use EXECUTE IMMEDIATE to execute any DDL inside a PLSQL procedure. Why make things complicated using the PARSE procedure supplied with the DBMS_SQL package.
Regards,
Aj

[debasisdas]

DBMS_SQL is the predecessor of EXECUTE IMMEDIATE.

that was used in the earlier versions not required if using 9i onwards.

It is recommended to use EXECUTE IMMEDIATE in latest versions.

[OraMaster]

This is better described here http://okjsp.pe.kr/seq/9789.