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.

notice.gif
Note: The Net8 Configuration Assistant configures this information in the listener.ora file during an Oracle8i installation.

To configure external procedures for the listener:

  1. In the navigator pane, expand Net8 Configuration > Local > Listeners.

  2. Select a listener.

  3. From the list in the right pane, select Listening Locations..

  4. Click Add Address. A new Address tab appears.

  5. Select IPC for the protocol and enter EXTPROC0 for the key value.

  6. From the list in the right pane, select Other Services.

  7. Click Add Service. A new Service tab appears.

  8. Enter exproc in the Program Name field, PLSExtProc in the SID field, and the Oracle home directory in the Oracle Home Directory field.

  9. Ensure the server is configured with a connect descriptor to access the external procedures, as described in Configure a Connect Descriptor for External Procedures.

  10. Choose File > Save Network Configuration.