proc demo

源文件test.pc

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

int main()
{
    EXEC SQL BEGIN DECLARE SECTION;
        char *sid = "orauser/pwd@170.8.2.91/dbname";
        char sTime[16];
    EXEC SQL END DECLARE SECTION;
    EXEC SQL CONNECT :sid;
    printf("%s",sqlca.sqlerrm.sqlerrmc);
    if(sqlca.sqlcode == 0)
        printf("CONNECT OK\n");
    else
        printf("CONNECT ERROR, sqlcode = %d\n", sqlca.sqlcode);

    EXEC SQL
        select insert_t into :sTime from cm_business_jnl where rownum =1;
    
    printf("%s\n",sTime);    
    return 0;
}

makefile文件

test :test.o
    cc -g  -o test   test.o  -L/home/oracle/product/10.2/db_1/lib  -lclntsh
test.o:test.c
    cc -g  -I.  -I/home/oracle/product/10.2/db_1/precomp/public -c test.c
test.c:test.pc
    proc include=/home/oracle/product/10.2/db_1/rdbms/public  parse=full unsafe_null=yes dbms=V8 mode=oracle lines=yes char_map=string  iname=test.pc

clean:
    rm test test.o test.c

收藏于 2013-10-10

来自于百度空间