originally posted by Raminder:
------------------------
What is the advantage of using 'Execute Immediate' over 'Execute'?
------------------------
with execute immediate you can execute a sql or a procedure dynamically, which can be very advantageous if your sql or procedure needs variable or parameter that is not fixed.