PRO*C入门实例

linux下编译命令：
将PC编译成C：proc parse=none iname=main.pc
将C编译成可执行文件：gcc -g -o main main.c -I$ORACLE_HOME/precomp/public -L$ORACLE_HOME/lib -lclntsh

#include "sqlca.h"
#include <stdio.h>
#include <stdlib.h>
#include <string.h>

void sql_error(char *msg) 
{ 
printf("\n%s %s\n", msg,(char *)sqlca.sqlerrm.sqlerrmc); 
EXEC SQL ROLLBACK RELEASE; 
exit(0);
}

int main() {

EXEC SQL INCLUDE sqlca;
EXEC Oracle OPTION (RELEASE_CURSOR = YES);
EXEC SQL WHENEVER SQLERROR DO sql_error(" ");

EXEC SQL BEGIN DECLARE SECTION;
VARCHAR oraCN[30];
VARCHAR consName[256];
EXEC SQL END DECLARE SECTION;

strcpy(oraCN.arr,"eic3/eic3@cjdb");
oraCN.len = strlen(oraCN.arr);
oraCN.arr[oraCN.len]='\0';

EXEC SQL CONNECT :oraCN;
printf("[OK Connected!]\n");

EXEC SQL select cons_name into :consName from c_cons where cons_id=10000;
consName.arr[consName.len]=0x00;
printf("%s\n",consName.arr);
EXEC SQL COMMIT WORK RELEASE;
return 0;

}