Difference Between Compiled and Interpreted PL/SQL

Question:  I have a question on choosing the compilation method in oracle.  I \have a choice between compiling and interpreted PL/SQL but I want to know the advantages of compiling vs. interpreted PL/SQL. 

What is the difference between compiled and interpreted PL/SQL?

Answer:  The main differences between compiling and interpreting is that compiling forces all pre-processing at once, while interpreted PL/SQL is done line-at-a-time:

• Interpreted: The code is parsed and changed to source code, one line at a time. Only one error at a time appears. Interpreted is flexible than compiled code and allows for more dynamic features such as late binding.

• Compiled: When a PL/SQL program is compiled, all code is parsed and semantic checked at once, and syntax many errors appear.

Also, compiling PL/SQL hides the source code (good for vendor code obfuscation), makes and compiling the code run faster, but is less flexible (as is no late binding). 

See this article for details on the differences between compiling and interpreted PL/SQL.

Guarantee your Success! Oracle is the world's most complex, robust and flexible database, considered impossible to master without a mentor. That's why all BC Oracle trainers are working professionals, experts in Oracle who share their tips and secrets.

Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.                      Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services   Copyright ? 1996 -  2012  All rights reserved. Oracle ? is the registered trademark of Oracle Corporation.