My Oracle Support Banner

VMS: Executing a DCL Command Using an External Procedure in Oracle 8 (Doc ID 73623.1)

Last updated on OCTOBER 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.2 to 8.0.5.1 [Release 8.0.3 to 8.0.5]
HP OpenVMS Alpha
HP OpenVMS Alpha

Purpose

Checked for currency on 25-NOV-2008.

The purpose of this note is to provide an example of executing a DCL command procedure using an
external procedure in Oracle 8. To use this procedure, configure the heterogeneous option (hoopt) in
your Oracle 8 code tree and install the DEC C compiler.

Scope




Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Set up your environment.
 Modify TNS_ADMIN:TNSNAMES.ORA.
 Modify TNS_ADMIN:LISTENER.ORA.
 Create the TNS_ADMIN:ORASRV_HO_EXTPROC.COM
 Create the shareable image.
 In SQL*Plus create the library and the procedure.
 Test the external procedure.
 
Possible errors.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.