怎样确定是否装上了 Pro*C

显示全部楼层 · 2005-3-23 04:36:07

我刚刚接触Pro*C precompiler 的概念.问一个傻傻的问题.
客户在HP UNIX 上装了Oracle 8.1.7, 还有aC++ 5.0,可是我都不知道他们是不是装上了Pro*C, 他们自己也搞不清楚.
在 $ORACLE_HOME/precomp/ 目录下, 我倒是看到了一堆目录,
admin, demo, doc, lib, mesg, public
可是进了demo 里一看, 根本就没有 proc.mk , sample.pc 等.
在admin 目录里, 只有ottcfg.cfg, shrept.lst
在lib 目录里, 有 cobsqlintf.o, ins_precomp.mk, libpgp.a, pdb.o, so2ed.o, env_precomp.mk, libots2c.a, o2m.o, pds.o, so2pt.o.
我怎样才能确定他们是否装上了Pro*C 呢?

千问 · 2005-3-23 04:36:07

[oracle@fcp2084 oracle]$ cd $ORACLE_HOME/bin
[oracle@fcp2084 bin]$ ls proc
proc
[oracle@fcp2084 bin]$ proc
Pro*C/C++: Release 10.1.0.2.0 - Production on Tue Apr 27 23:22:52 2004
Copyright (c) 1982, 2004, Oracle.All rights reserved.
System default option values taken from: /opt/oracle/products/9.2.0/precomp/admin/pcscfg.cfg
Option NameCurrent ValueDescription
-------------------------------------------------------------------------------
auto_connect no
Allow automatic connection to ops$ account
char_map charz
Mapping of character arrays and strings
close_on_commitno
Close all cursors on COMMIT
cmax 100
CMAX Value for connection pool
cmin 2
CMIN Value for connection pool
cincr
1
CINCR Value for connection pool
ctimeout 0
CTIMEOUT Value for connection pool
cnowait0
CNOWAIT Value for connection pool
code kr_c The type of code to be generated
comp_charset multi_byte The character set type the C compiler supports
config defaultOverride system configuration file with another
cpool
no
Support connection pooling
cpp_suffix *none* Override the default C++ filename suffix
dbms native v6/v7/v8 compatibility mode
def_sqlcodeno
Generate '#define SQLCODE sqlca.sqlcode' macro
define *none* Define a preprocessor symbol
duration transactionSet pin duration for objects in the cache
dynamicoracle Specify Oracle or ANSI Dynamic SQL Semantics
errors yes
Whether error messages are sent to the terminal
errtype*none* Name of the list file for intype file errors
fips none FIPS flagging of ANSI noncompliant usage
header *none* Specify file extension for Precompiled Headers
hold_cursorno
Control holding of cursors in the cursor cache
iname
*none* The name of the input file
include*none* Directory paths for included files
intype *none* The name of the input file for type information
lines
no
Add #line directives to the generated code
lname
*none* Override default list file name
ltype
short
The amount of data generated in the list file
maxliteral 1024 Maximum length of a generated string literal
maxopencursors 10
Maximum number of cached open cursors
mode oracle Code conformance to Oracle or ANSI rules
native_types no
Support for native float/double
nls_char *none* Specify National Language character variables
nls_localno
Control how NLS character semantics are done
objectsyes
Support object types
oname
*none* The name of the output file
oraca
no
Control the use of the ORACA
pagelen80
The page length of the list file
parse
full Control which non-SQL code is parsed
prefetch 1
Number of rows pre-fetched at cursor OPEN time
release_cursor no
Control release of cursors from cursor cache
select_error yes
Control flagging of select errors
sqlcheck syntax Amount of compile-time SQL checking
sys_include/usr/lib/gcc-liDirectory where system header files are found

/usr/lib/gcc-lib/i386-redhat-linux/2.96/include

/usr/lib/gcc-lib/i486-suse-linux/2.95.3/include

/usr/include

threadsno
Indicates a multi-threaded application
type_codeoracle Use Oracle or ANSI type codes for Dynamic SQL
unsafe_nullno
Allow a NULL fetch without indicator variable
userid *none* A username/password [@dbname] connect string
utf16_charsetnchar_charsetThe character set form used by UTF16 variables
varcharno
Allow the use of implicit varchar structures
versionrecent Which version of an object is to be returned
PCC-F-02135, CMD-LINE:User asked for help
[oracle@fcp2084 bin]$

千问 · 2005-3-23 04:36:07

非常感谢Biti 大师.

在$ORACLE_HOME/bin/ 下面, 根本就没有proc 这个文件. 看样子他们的确是没装啊......

千问 · 2005-3-23 04:36:07

安装时要选择CLIENT，在CLIENT下定制安装肯定就OK

千问 · 2005-3-23 04:36:07

嗯, 我没装过Pro*C, 以后有机会装装看. 谢谢楼上.