Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
# Generic Visual C++ makefile for Oracle9i PL/SQL Native Compilation.
# Modify VC_HOME, ORACLE_HOME, and NATIVE_DIR (excluding optional sub dirs) to
# match installation.
#
# System PATH (not user path) must include bin directory for Visual C++.
#
# The makefile is called by Oracle with the following command line:
# -f
# CC= LD=
# /[/].dll
# where the optional component is used if you have set the init.ora
# parameter plsql_native_library_subdir_count to a value larger than 0.
#
# In an installation where Visual C++ is installed in
# C:\Program Files\Microsoft Visual Studio\VC98 and Oracle9i's home is
# D:\oracle\products\ora90, the following init.ora parameters must be set:
# PLSQL_NATIVE_C_COMPILER='C:\PROGRA~1\MICROS~2\VC98\Bin\CL.EXE'
# PLSQL_NATIVE_LIBRARY_DIR='D:\Oracle\products\ora90\plsql\native'
# PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT=0
# PLSQL_NATIVE_LINKER='C:\PROGRA~1\MICROS~2\VC98\Bin\LINK.EXE'
# PLSQL_NATIVE_MAKE_FILE_NAME='D:\Oracle\products\ora90\plsql\native\spnc_makefile.mk'
# PLSQL_NATIVE_MAKE_UTILITY='C:\PROGRA~1\MICROS~2\VC98\Bin\NMAKE.EXE /NOLOGO'
#
# If you have successfully compiled and linked a DLL in a session and you later
# recompile the same PL/SQL object the linker will fail because the DLL is
# locked by Oracle. The only solution I've found for this problem is to log off
# and on again.
# Note that I only managed to get it working when I started the
# OracleService as a SPECIFIC user with the correct path to C++ etc. It
# did not work when the service was started as LocalSystem. Also note the
# 8.3-notation for some filenames. THIS IS CRUCIAL! Find out with dir/X what
# the 8.3-notation for a given file should be.
#
# 2001-??-?? Finn Ellebaek Nielsen, ChangeGroup ApS.
# - Initial Creation.
# 2002-04-02 Martijn Hinten, Cumquat Information Technology BV, The Netherlands.
# - Amended for own environment.
#
VC_HOME=C:\PROGRA~1\MICROS~2\VC98
ORACLE_HOME=D:\Oracle\products\ora90
NATIVE_DIR=\$(ORACLE_HOME)\plsql\native
LOG=> "d:\temp\makefile.log" 2> d:\temp\makefile.err"
CCOPT=/MT /W3 /GX /O2 /YX /FD /c /nologo /I\$(VC_HOME)\include /I\$(ORACLE_HOME)\plsql\include /I\$(ORACLE_HOME)\oci\include
LDOPT=/NOLOGO /DLL /LIBPATH:\$(VC_HOME)\Lib /LIBPATH:\$(ORACLE_HOME)\LIB orapls9.lib
DEL=del /s
.SUFFIXES: .c .obj .dll
.c.dll:
\$(CC) \$(CCOPT) /Fo\$*.obj \$*.c \$(LOG)
\$(LD) \$(LDOPT) /OUT:\$*.dll \$*.obj \$(LOG)
-\$(DEL) \$(NATIVE_DIR)\\$(*B).obj \$(NATIVE_DIR)\\$(*B).lib \$(NATIVE_DIR)\\$(*B).exp \$(LOG)
.c.obj:
\$(CC) \$(CCOPT) /Fo\$*.obj \$*.c \$(LOG)
.obj.dll:
\$(LD) \$(LDOPT) /OUT:\$*.dll \$*.obj \$(LOG)
-\$(DEL) \$(NATIVE_DIR)\\$(*B).obj \$(NATIVE_DIR)\\$(*B).lib \$(NATIVE_DIR)\\$(*B).exp \$(LOG)
clean:
cd \$(NATIVE_DIR) \$(LOG)
-\$(DEL) \$(NATIVE_DIR)\*.c \$(NATIVE_DIR)\*.obj \$(NATIVE_DIR)\*.lib \$(NATIVE_DIR)\*.exp \$(NATIVE_DIR)\*.dll \$(LOG)
