What do the contents of extproc
file look like? I'm aware that my extproc.ora
file is missing, and I'd like to create one in it's absence.
The instructions here tell me to:
Configure the Oracle extproc.ora to point to the location of the
ST_Geometry library file.Make a backup copy of the extproc.ora file on the Oracle server. Open
the extproc.ora file and alter it to point to the location of the
st_shapelib.dll (Windows) or libst_shapelib.so (Linux or UNIX)
library.The following line is added
to extrproc.ora to point to the ST_Geometry library in that directory:SET EXTPROC_DLLS=ONLY:C:\mylibraries\st_shapelib.dll
Save and close the extproc.ora file.
I've tried creating an extproc.ora
file from scratch, but I don't really know what I'm doing: SET EXTPROC_DLLS=ONLY:C:\mylibraries\st_shapelib.dll
.
Not surprisingly, the file fails.
Rather than just dream up what I think the file should contain, I'd like to copy an existing example. I've searched the web, but have not come up with any complete examples of extproc.ora
. Not even in the Oracle documentation: https://docs.oracle.com/database/121/NETAG/advcfg.htm#NETAG0133
What is an example of an extproc.ora file?
Best Answer
Why do you expect that "there must be more to it"?
extproc.ora
simply sets environment variables for theextproc
daemon, which is used to execute code for external stored procedures, and for procedures themselves. There is some documentation in the application development guide.The one environment variable that seems to be recognized by
extproc
itself isEXTPROC_DLLS
that you mention, which determines the locations where the daemon looks for shared libraries. If set toONLY:<path>
it won't look in$ORACLE_HOME/bin
or$ORACLE_HOME/lib
.Any other variables set in
extproc.ora
are simply passed on to the environment where the external code runs, so they would be specific to each library.