Configure External Procedures for the Listener
An external procedure is a function that is written in the C programming
language and stored in a shared library on the server. In order for an Oracle
database to connect to an external procedure, the listener.ora file must be configured with a protocol address and service information for external procedures in the listener.ora file.
| Note: The Net8 Configuration Assistant configures this information in the listener.ora file during an Oracle8i installation.
|
To configure external procedures for the listener:
- In the navigator pane, expand Net8 Configuration > Local > Listeners.
- Select a listener.
- From the list in the right pane, select Listening Locations..
- Click Add Address. A new Address tab appears.
- Select IPC for the protocol and enter EXTPROC0 for the key value.
- From the list in the right pane, select Other Services.
- Click Add Service. A new Service tab appears.
- Enter exproc in the Program Name field, PLSExtProc in the SID field, and the Oracle home directory in the Oracle Home Directory field.
- Ensure the server is configured with a connect descriptor to access the
external procedures, as described in Configure a Connect Descriptor for External Procedures.
- Choose File > Save Network Configuration.