Advanced Oracle PL/SQL Developer's Guide - Second Edition

Practice exercise

• Which of the following statements are true about the extproc process?
  1. It loads the shared library of the external C program.
  2. It is started by the PL/SQL runtime engine.
  3. It is a session-specific process.
  4. The extproc process compiles the C program while loading.
• Oracle 7 introduced the external procedure feature for sending e-mails from PL/SQL.
  1. True
  2. False
• Determine the effect of dropping the library object that has been used in a PL/SQL call specification while it is still in use:
  1. The PL/SQL wrapper method gets invalidated.
  2. The shared library gets corrupted.
  3. The PL/SQL wrapper method still works fine as it has already been executed once.
  4. The PL/SQL wrapper method gives no output.
• Examine the following TNSNAMES.ora and LISTENER.ora entries and ...