I have some questions concerning using external procedures with Oracle.
I am running Oracle 8 on a single Windows 95 machine and need to call a
number of external procedures written in Delphi 3 from a SQL*Plus
session...
- How do I load the DLL so that it stays resident for each DLL procedure?
This is needed to preserve the status of the DLL rather than loading the
DLL and freeing the DLL on each DLL procedure call.
- Do I run "LSNRTCL80.EXE start" to do this?
- My LISTENER.ORA file contains the lines
LISTENER =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = ORCL)
)
SID_LIST_LISTENER =
(SID_DESC = (SID_NAME = extproc) (PROGRAM = extproc)
)
Are these correct?
- My TNSNAMES.ORA file contains the lines:
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(Key = ORCL)
)
(CONNECT_DATA = (SID = extproc)
)
)
Is this correct?
- How does the ORA file entries relate to my actual library which is in
"C:\MY DOCUMENTS\MYLIB.DLL"? Is there some other association I need?
- When I run a PL/SQL procedure which calls two DLL procedures the second
DLL procedure does not remember the DLL status... Is there something I have
forgotten to do here?
Please Help!
Mel Christie
--
Technical Director
Pure Goodness Services
http://www.puregoodness.com
Received on Tue Aug 18 1998 - 06:08:01 CDT