이진우의 블로그

1. Oracle Client 설치 - profile 세팅 및 필수 PKG, Patch 확인 ORACLE_BASE, ORACLE_HOME, PATH, LD_LIBRARY_PATH, SHLIB- tnsname.ora- tnsping 통해 DB connection 체크 2. Precompiler 세팅- Precompiler 설정 파일에 내용 추가vi $(ORACLE_HOME)/precomp/admin/pcscfg.cfgsys_include=($ORACLE_HOME)/precomp/public,/usr/include

makefileCC=ccPROC=procCFLAGS=+DD64LIB=-L$(ORACLE_HOME)/lib -IclntshINC=-I$(ORACLE_HOME)/precomp/publicPROCFLAGS=parse=fulltest: test.pc$(PROC) $(PROCFLAGS) iname=$(@:=.pc)$(CC) $(CFLAGS) -o $@ $@.c $(LIB) $(INC) test.pc#include #include int main() {/* Start Session */EXEC SQL BEGIN DECLARE SECTION;VARCHAR user[20], pass[20], tnsname[20];char name[20];int id;int i = 0;const char* uid = "SCOTT";co..

#include #include main() { MYSQL *conn; MYSQL_RES *res; MYSQL_ROW row; char *server = "localhost"; char *user = "root"; char *password = "PASSWORD"; /* set me first */ char *database = "mysql"; conn = mysql_init(NULL); /* Connect to database */ if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s\n", mysql_error(conn)); exit(1); } /* send SQL query *..