<<<<<<<<<<<<<<<<source code>>>>>>>>>>>>>>>>>

#include <sys/errno.h>

#include <stdio.h>

#include <netdb.h>

#include <string.h>

#define sql_msg sqlca.sqlerrm.sqlerrmc

EXEC SQL INCLUDE sqlca.h;

main() {

/*sqlEnv();*/

sqlLinitial();

sql_insert();

}

sqlEnv() {

char Env[100];

setenv("NLS_LANG=American_America.K016KSC5601");

sprintf(Env, "ORACLE_SID=%s", "ORCL");

setenv(Env);

setenv("ORACLE_HOME=/export/home/OraHome1");

}

sqlLinitial() {

EXEC SQL connect "scott" identified by "tiger" ;

EXEC SQL WHENEVER SQLERROR GOTO stop_st;

printf("\n Sqlplus initial Success\n");

stop_st :

EXEC SQL ROLLBACK WORK;

printf("\n error message = %s", sql_msg);

}

<<<<<<<<<<<<<<<<<컴파일시 에러>>>>>>>>>>>>>>>>>>>>

$ make -f proc.mk EXE=sqltest2 OBJS=sqltest2.o build

proc iname=sqltest2

System default option values taken from: /export/home/OraHome1/precomp/admin/pcscfg.cfg

Syntax error at line 30, column 19, file sqltest2.pc:

Error at line 30, column 19 in file sqltest2.pc

EXEC SQL CONNECT scott IDENTIFIED BY tiger;

..................1

PCC-S-02201, Encountered the symbol "scott" when expecting one of the following:

:

Syntax error at line 0, column 0, file sqltest2.pc:

Error at line 0, column 0 in file sqltest2.pc

PCC-S-02201, Encountered the symbol "<eof>" when expecting one of the following:

; : an identifier, end-exec, random_terminal

Error at line 0, column 0 in file sqltest2.pc

PCC-F-02102, Fatal error while doing C preprocessing

*** Error code 1

make: Fatal error: Command failed for target `sqltest2.o'