[정보] Precompiler(proc) 옵션

오라클 proc 소스파일(.pc)을 C 소스파일(.c)로 변환 시에 proc 컴파일러를 사용하는데, 이 때 사용가능한 옵션 및 설명은 아래 표와 같다.

Syntax	Default	Specifics
AUTO_CONNECT={YES | NO}	NO	Automatic CLUSTER$ account connection before the first executable statement.
CHAR_MAP={VARCHAR2 | CHARZ | STRING | CHARF} *	CHARZ	Mapping of character arrays and strings.
CLOSE_ON_COMMIT={YES | NO}	NO	Close all cursors on COMMIT.
CODE={ANSI_C | KR_C | CPP}	KR_C	Kind of C code generated.
COMP_CHARSET={MULTI_BYTE | SINGLE_BYTE}	MULTI_BYTE	The character set type the C/C++ compiler supports.
CONFIG=filename	none	User's private configuration file.
CPP_SUFFIX=extension	none	Specify the default filename extension for C++ output files.
DBMS={V7 | NATIVE | V8}	NATIVE	Compatibility (Oracle7, Oracle8, Oracle8i, Oracle9i, or the database version to which you are connected at precompile time).
DEF_SQLCODE={YES | NO}	NO	Generate a macro to #define SQLCODE.
DEFINE=name *	none	Define a name for use by the Pro*C/C++ precompiler.
DURATION={TRANSACTION | SESSION}	TRANSACTION	Set pin duration for objects in the cache.
DYNAMIC={ANSI | ORACLE}	ORACLE	Specifies Oracle or ANSI SQL semantics.
ERRORS={YES | NO}	YES	Where to direct error messages (NO means only to listing file, and not to terminal).
ERRTYPE=filename	none	Name of the listing file for intype file error messages.
FIPS={NO | SQL89 | SQL2 | YES} *	none	Whether to flag ANSI/ISO non-compliance.
HEADER=extension	none	Specify file extension for precompiled header files.
HOLD_CURSOR={YES | NO} *	NO	How cursor cache handles SQL statement.
INAME=]filename	none	Name of the input file.
INCLUDE=pathname *	none	Directory path for EXEC SQL INCLUDE or #include statements.
INTYPE=filename	none	Name of the input file for type information.
LINES={YES | NO}	NO	Whether #line directives are generated.
LNAME=filename	none	Name of listing file.
LTYPE={NONE | SHORT | LONG}	none	Type of listing file to be generated, if any.
MAXLITERAL=10..1024	1024	Maximum length (bytes) of string literals in generated C code.
MAXOPENCURSORS=5..255 *	10	Maximum number of concurrent cached open cursors.
MODE={ANSI | ISO | ORACLE}	ORACLE	ANSI/ISO or Oracle behavior.
NLS_CHAR=(var1, ..., varn)	none	Specify multibyte character variables.
NLS_LOCAL={YES | NO}	NO	Control multibyte character semantics.
OBJECTS={YES | NO}	YES	Support of object types.
ONAME=]filename	iname.c	Name of the output (code) file.
ORACA={YES | NO} *	NO	Whether to use the ORACA.
PAGELEN=30..256	80	Page length of the listing file.
PARSE={NONE | PARTIAL | FULL}	FULL	Whether Pro*C/C++ parses (with a C parser) the.pc source.
PREFETCH=0..65535	1	Speed up queries by pre-fetching a given number of rows.
RELEASE_CURSOR={YES | NO} *	NO	Control release of cursors from cursor cache.
SELECT_ERROR={YES | NO} *	YES	Flagging of SELECT errors.
SQLCHECK={SEMANTICS | SYNTAX} *	SYNTAX	Amount of precompile time SQL checking.
SYS_INCLUDE=pathname	none	Directory where system header files, such as iostream.h, are found.
THREADS={YES | NO}	NO	Indicates a shared server application.
TYPE_CODE={ORACLE | ANSI}	ORACLE	Use of Oracle or ANSI type codes for dynamic SQL.
UNSAFE_NULL={YES | NO}	NO	UNSAFE_NULL=YES disables the ORA-01405 message.
USERID=username/password[@dbname]	none	Username/password[@dbname] connect string.
UTF16_CHARSET={NCHAR_CHARSET | DB_CHARSET}	NCHAR_CHARSET	Specify the character set form used by UNICODE(UTF16).
VARCHAR={YES | NO}	NO	Allow the use of implicit VARCHAR structures.
VERSION={ANY | LATEST | RECENT} *	RECENT	Which version of an object is to be returned.

[출처] https://docs.oracle.com/cd/B12037_01/appdev.101/a97269/pc_10opt.htm