摘要: Oracle Precompiler: Pro*C/C++ Release 3.0 MessagesPCC-02010: found end-of-file while scanning string literalCause: A string in a SQL statement, which should be delimited by single quotation marks, was not terminated properly.Action: Check that all strings are delimited.PCC-02011: found identifier gr 阅读全文
posted @ 2012-02-10 18:42 leanman 阅读(4146) 评论(0) 推荐(0)
摘要: 有了oracle环境后,开始在Linux下编写proc*c 初始例子一般都是一个连接到数据库的程序:#include <stdio.h>#include <string.h>#include <stdlib.h>#include "sqlca.h"EXEC SQL BEGIN DECLARE SECTION; char *uid = "scott/tiger@CENTOS";EXEC SQL END DECLARE SECTION;int main(){ EXEC SQL CONNECT :uid; printf(&q 阅读全文
posted @ 2012-02-10 18:37 leanman 阅读(4240) 评论(0) 推荐(0)
摘要: Linux中在Oracle安装完毕以后,如果重新启动Linux ,Oracle是不会自动启动的,你可以通过手动调用dbstart命令来进行启动,不过这样似乎也很繁琐.我们可以通过配置Oracle的自动启动脚本,然后利用Linux的Service来启动Oracle服务器.首先在/etc/init.d/目录下配置Oracle的服务文件.touch oracle10gchmod a+x oracle10g然后编辑此oracle10g文件.内容如下.# !/bin/bash# whoami# root# chkconfig: 345 51 49# /etc/init.d/oracle10g# desc 阅读全文
posted @ 2012-02-10 10:59 leanman 阅读(2117) 评论(0) 推荐(0)