Connecting Tech Pros Worldwide Help | Site Map

Execute Immediate VS Dynamic SQL (DBMS_SQL)

Member
 
Join Date: Sep 2007
Posts: 55
#1: Mar 22 '09
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's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,500
#2: Mar 23 '09

re: Execute Immediate VS Dynamic SQL (DBMS_SQL)


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's Avatar
Member
 
Join Date: Aug 2009
Location: Pune, India
Posts: 76
#3: Aug 4 '09

re: Execute Immediate VS Dynamic SQL (DBMS_SQL)


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