linux环境下oracleproc程序的编写简单范例.docVIP

Linux 环境下PRO*C程序的编写简单范例 Oracle 数据库版本 ? Linux 版本 Red Hat Enterprise AS3 环境介绍：oracle 数据库和服务均安装到 linux 主机上 一、oracle 用户的环境变量设置如下: [oracle@guohui6 oracle]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs ORACLE_BASE=/mydatafile2/app/oracle; export ORACLE_BASE ORACLE_SID=ORCL;export ORACLE_SID #ORACLE_SID=AUXY;export ORACLE_SID ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1;export ORACLE_HOME PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH NLS_LANG=american_america.ZHS16GBK;export NLS_LANG export PATH unset USERNAME [oracle@guohui6 oracle]$ 二、查看oracle 用户的登录环境: [oracle@guohui6 oracle]$ id uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba) [oracle@guohui6 oracle]$ env REMOTEHOST= HOSTNAME=guohui6 SHELL=/bin/bash TERM=vt100 HISTSIZE=1000 NLS_LANG=american_america.ZHS16GBK QTDIR=/usr/lib/qt-3.1 OLDPWD=/home/oracle/backuprestor101/proc_code USER=oracle LD_LIBRARY_PATH=/mydatafile2/app/oracle/oracle/product/10.2.0/db_1/lib:/usr/lib:/usr/local/lib LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: ORACLE_SID=ORCL ORACLE_BASE=/mydatafile2/app/oracle MAIL=/var/spool/mail/oracle PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/mydatafile2/app/oracle/oracle/product/10.2.0/db_1/bin INPUTRC=/etc/inputrc PWD=/home/oracle LANG=en_US.UTF-8 LAMHELPFILE=/etc/lam/lam-helpfile SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=1 HOME=/home/or