Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

27-20.	What are some of the similarities and differences between native PL/SQL procedures and external procedures?
27-21.	How does being able to access external procedures overcome some of the shortcomings of the PL/SQL language?
27-22.	What steps are necessary to create and call an external procedure?
27-23.	Are there any disadvantages with the current implementation of external procedures?
27-24.	When attempting to call an external procedure you just wrote, you receive the following error: ORA-28575: unable to open RPC connection to external procedure agent What could be causing this error, and how can you fix it?
27-25.	What does the BY REFERENCE option do in the PARAMETERS clause?
27-26.	How does the concept of dynamic linking make the current implementation of external procedures more efficient?
27-27.	What advantages are there to placing PL/SQL wrapper procedures inside a package instead of creating them as standalone program units?
27-28.	You are about to drop a library you believe is not being used by any users. How can you ensure that the library is not referenced by any existing database code before you remove the library?
27-29.	This problem has a larger scope than most others in this book. It’s a case study involving the following situation: You would like to provide a facility to other programmers to log debugging messages to an operating system file. Your colleague (who is a C programmer) has written a Unix shared library (/usr/local/bin/debug.sl), that contains a procedure ...