1Z0-146 · Question #18
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in…
The correct answer is D. The PL/SQL subprogram that depends on the external C program becomes invalid. After the external procedure completes, extproc remains active throughout your Oracle session. Thus, you incur the cost of spawning extproc only once, no matter how many calls you make. Still, you should call an external procedure only when the computational benefits outweigh…
Question
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
Options
- AThe corresponding shared library is also removed from the system.
- BPL/SQL subprograms can be used to invoke the external C procedure.
- CThe existing extproc process is terminated and a new extproc is started.
- DThe PL/SQL subprogram that depends on the external C program becomes invalid.
How the community answered
(26 responses)- A4% (1)
- B12% (3)
- C4% (1)
- D81% (21)
Explanation
After the external procedure completes, extproc remains active throughout your Oracle session. Thus, you incur the cost of spawning extproc only once, no matter how many calls you make. Still, you should call an external procedure only when the computational benefits outweigh the cost. When you log off, extproc is killed. Note that the Listener must start extproc on the system that runs the Oracle server. Starting extproc on a different system is not supported.
Topics
Community Discussion
No community discussion yet for this question.