Re: Callouts to external programs under Oracle8/OpenVMS

From: Saad Ahmad <saad.ahmad_at_mchugh.com>
Date: 28 Apr 1998 22:55:50 GMT
Message-ID: <01bd72f8$c8d68600$2207030a@sahmad-pc.mfa.com>

The machine already had Oracle 7 so the listener name has been changed. Oracle SID is proto8
host name is marcel
1521 was being used by v7 listener so this is using 1522 OS is HP-UX 10.20

################
# Filename......: listener.ora
# Name..........: marcel.world

# Date..........: 21-APR-98 14:29:22

################

ORA8LISTENER =
(ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= proto8.world)


        )
        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= proto8)


        )
        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= extproc)


        )
        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = marcel)


          (Port = 1522)


        )

  )
STARTUP_WAIT_TIME_ORA8LISTENER = 0
CONNECT_TIMEOUT_ORA8LISTENER = 0
TRACE_LEVEL_ORA8LISTENER = OFF
SID_LIST_ORA8LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = proto8)
      (ORACLE_HOME = /opt/oracle/product/8.0.3)
      )
    (SID_DESC =
      (SID_NAME = extproc)
      (PROGRAM=extproc)

)
)

##############
# Filename......: tnsnames.ora
# Node..........: spunky.com
# Date..........: 26-MAY-95 16:11:52
################

proto8 =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = mfaoracle.com)


          (PROTOCOL = TCP)


          (Host = marcel)


          (Port = 1522)


        )

    )
    (CONNECT_DATA = (SID = proto8)
    )
  )
extproc_connection_data =

        (DESCRIPTION =
                (ADDRESS =
                (PROTOCOL = IPC)
                (KEY = proto8)

            )
        (CONNECT_DATA = (SID=extproc))
           )

##### END of tnsnames.ora ####

For testing see the demo program under $ORACLE_HOME/plsql/demo make extproc.sl
made the shared library. The makefile exists there and it includes all the right stuff

On 8.0.3 on HP-UX 10.20, the version I had - the demo program itself had several
problems. One problem was with the PercentComm function. I commented out references
to it in the demo.

-good luck, you'll need it ...
Saad Ahmad
saad.ahmad_at_mchugh.com

Chr. Dethlefsen <chrd_at_novo.dk> wrote in article <3545DD4B.727A5D3C_at_novo.dk>...

> Would somebody who has succeded with callout from PL/SQL
> (Oracle8.03/OpenVMS) to an external program please give information
> about listener.ora, tnsnames.ora, extproc, and way of linking the
> external program.
> 
> Kind Regards
> 
> Chr. Dethlefsen
> 
>

Received on Tue Apr 28 1998 - 17:55:50 CDT