External procedures are procedures that are called from another program, but are written in a different language. An example would be a PL/SQL program calling one or more C routines that are required to perform special-purpose processing.
In order for the Oracle database to connect to an external procedure, the database server must be configured with a net service name to access external procedures.
|
Note: Oracle Net Configuration Assistant automatically creates a net service name for external procedures during installation. |
To configure a database server for external procedures:
Ensure that the listener is configured for external procedures, as described in Configure External Procedures for the Listener.
Create a net service name in the tnsnames.ora
file on the database. Ensure that the connect descriptor information
matches the information configured for the listener.
Choose File > Save Network Configuration.