Differencies of using dynamic SQL with EXECUTE IMMEDIATE and DBMS_SQL package

EXECUTE IMMEDIATE	DBMS_SQL
Native integral part of language	Oracle supplied package
Simpler, faster, easier	Complex and lengthy
Support user-defined, object types and collections, can return record	Doesn't support user-defined, object types and collections, can not return record
Can not process with large SQL statement	Can process large SQL statement (more than 32 KB approximately)