#include "ocilib.h"
   
int main()
{
    if (OCI_Initialize(err_handler, NULL, OCI_ENV_DEFAULT) == FALSE)
    	return EXIT_FAILURE;

    /* ... code application ... */

    OCI_Cleanup();

    return EXIT_SUCCESS;
}				
				

    OCI_Connection *cn;
    
    /* .... */
    
    cn = OCI_CreateConnection("Database", "user", "password", OCI_SESSION_DEFAULT);
    
    if (cn != NULL)
    {
        printf("%s\n", OCI_GetVersionServer(cn));
         
        /* ... code application ... */
        
        OCI_FreeConnection(cn);
    }
     
    /* .... */
    

typedef void (*POCI_ERROR) (OCI_Error *err);

void ErrorHandler(OCI_Error *err)
{
    int sql_code = OCI_ErrorGetOCICode(err);
    
    if (sql_code != 0) 
    {
        printf( "Code : ORA-%05i\n"
                "Msg : %s\n",
                sql_code, OCI_ErrorGetString(err));
    }
}

 
    OCI_Connection *cn;
    OCI_Statement *st;
     
    /* ... */
    
    st = OCI_CreateStatement(cn);
    
    OCI_ExecuteStmt(st, "delete from my_table where code is null");
    
    printf("%d row deleted", OCI_GetAffectedRows(st));
    
    OCI_Commit(cn);
    
    OCI_FreeStatement(st);
     
    /* ... */
    

    
    OCI_Connection *cn;
    OCI_Statement *st;
    int code;
    
    /* ... */
    
    st = OCI_CreateStatement(cn);
    
    OCI_Prepare(st, "delete from test_fetch where code = :code");
    OCI_BindInt(st, ":code", &code);
    
    code = 3;
    OCI_Execute(st);
    printf("%d row deleted"; OCI_GetAffectedRows(st));
    
    code = 56;
    OCI_Execute(st);
    printf("%d row deleted"; OCI_GetAffectedRows(st));
         
    OCI_Commit(cn);
    
    /* ... */   
    

    OCI_Connection *cn;
    OCI_Statement *st;
    int code;
    char name[30];
    char value[20];
    
    /* ... */
    
    st = OCI_CreateStatement(cn);
    
    OCI_Prepare(st, "insert into my_table values(:code, :name, :value)");
    OCI_BindInt(st, ":code", &code);
    OCI_BindString(st, ":name", name, 30);
    OCI_BindString(st, ":value", value, 20);
    
    for (code = 1; code < 10000; code++);
    {
        sprintf(name, "name %i", code);
        sprintf(value, "value %i", code);
    
        OCI_Execute(st);
    }
        
    OCI_Commit(cn);
    
    /* ... */ 
    

    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;
   
    /* ... */
     
    st = OCI_CreateStatement(cn); 
    
    OCI_ExecuteStmt(st, "select * from test_fetch");
    
    rs = OCI_GetResultset(st);
    
    while (OCI_FetchNext(rs))
    {
        printf("code: %i, action : %s, price : %g, date %s\n",
        	   OCI_GetInt(rs, 1) , OCI_GetString(rs, 2),
        	   OCI_GetDouble(rs,3), OCI_GetString(rs,4));
    }
    
    printf("\n%d row(s) fetched\n", OCI_GetRowCount(rs));
    
    /* .... */
    

  
    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;
    
    /* ... */
    
    st = OCI_CreateStatement(cn); 
    
    OCI_ExecuteStmt(st, "select * from test_fetch");
    
    rs = OCI_GetResultset(st);
    
    while (OCI_FetchNext(rs))
    {
        printf("code: %i, action : %s, price : %g, date %s\n",
        OCI_GetInt2(rs, "CODE") , OCI_GetStrin2g(rs, "ACTION"),
        OCI_GetDouble2(rs,"PRICE"), OCI_GetString2(rs,"DATE"));
    }
    
    printf("\n%d row(s) fetched\n", OCI_GetRowCount(rs));
    
    /* .... */
    

 
    OCI_Connection *cn;
    OCI_Statement *st1, *st2;
    OCI_Resultset *rs;
    
    /* ... */
    
    st1 = OCI_CreateStatement(cn);
    st2 = OCI_CreateStatement(cn);
    
    int code;
    
    OCI_ExecuteStmt(st1, "select code from my_table");
    OCI_Prepare(st2, "delete from my_table2 where code_ref = :code");
    OCI_Bind(st2, ":code", &code);
    
    rs = OCI_GetResultset(st);
    
    while (OCI_FetchNext(rs))
    {
        code = OCI_GetInt(rs, 1);
    
        OCI_Execute(st2);
    } 
    
    /* ... */
    

    
	OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;
    OCI_Column *col;
    
    /* ... */
     
    st = OCI_CreateStatement(cn);
    
    OCI_ExecuteStmt(st, "select * from my_table");
    
    rs = OCI_GetResultset(st);
    nb = OCI_GetColumnCount(rs);
    
    for(i = 1; i <= nb; i++)
    {
        col = OCI_GetColumn(rs, i);
     
        printf("%-20s%-10s%-8i%-8i%-8i%-s\n",
                OCI_GetColumnName(col),
                OCI_GetColumnSQLType(col),
                OCI_GetColumnSize(col),
                OCI_GetColumnPrecision(col),
                OCI_GetColumnScale(col),
                OCI_GetColumnNullable(col) == TRUE ? "Y" : "N");
    }
    
    /* ... */
    

    OCI_Connection *cn;
    OCI_Statement *st;
   
    /* ... */
    
    st = OCI_CreateStatement(cn);
   
    OCI_Prepare(st, "begin :n := trunc(sysdate+1)-trunc(sysdate-1); end;");
    OCI_BindInt(st, ":n", &n);
    OCI_Execute(st);
     
    printf("Result : %i\n", n);
     
    /* ... */
    

    OCI_Connection *cn;
    OCI_Statement *st;
     
    /* ... */
    
    st = OCI_CreateStatement(cn);
    st2 = OCI_CreateStatement(cn);
    
    OCI_Prepare(st, "begin open :c for select * from my_table; end;");
    OCI_BindStatement(st, ":c", st2);
    OCI_Execute(st);
     
    rs = OCI_GetResultset(st2);
    
    while (OCI_FetchNext(rs))
    {
        printf("mon nom est %s\n", OCI_GetString(rs, 1));
    }
    
    /* ... */
    

	
	    OCI_Connection *cn;
	    OCI_Statement *st; 
	    OCI_Resultset *rs; 
	    
	    /* ... */
	   
	    st  = OCI_CreateStatement(cn);
	
	    OCI_Prepare(st, "update my_table set content = content || to_char(code) returning code, content into :i, :s");
	    OCI_RegisterInt(st, ":i");
	    OCI_RegisterString(st, ":s", 50);
	
	    /* mise à jour des données */   
	    
	    OCI_Execute(st);
	
	    /* fetch des données modifiées */   
	   
	    rs = OCI_GetResultset(st);
	
	    while (OCI_FetchNext(rs))
	    {
	        printf("code : %i - content : %s\n", OCI_GetInt(rs, 1), CI_GetInt(rs, 2));
	    }
	
	    printf("count : %i\n", OCI_GetRowCount(rs));
	
	  
	    OCI_Commit(cn);
	
	    
	    /* ... */
	
	

    OCI_Connection *cn;
    OCI_Statement *st;
     
    int tab_int[10000];
    char tab_str[10000][21];
    
    /* ... */
    
    OCI_Prepare(st, "insert into my_table values(:i, :s)");
    OCI_BindArraySetSize(st, 10000);
    OCI_BindArrayOfInts(st, ":i", tab_int);
    OCI_BindArrayOfStrings(st, ":s", tab_str, 20);
    
    /* filling arrays */
    
    for(i=0;i<10000;i++)
    {
        tab_int[i] = i+1;
        sprintf(tab_str[i],"Name %d",i+1);
    }
     
    /* execute */
    
    OCI_Execute(st);
    
    printf("row processed : %d\n", OCI_GetAffectedRows(st));
     
    /* ... */
    

    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Lob *lob;
    FILE *f;
    unsigned char buffer[1024];
    int size;
     
    /* ... */
       
    st = OCI_CreateStatement(cn);
    
    f = fopen("My file", "rb");
    
    if (f != NULL)
    {
        fseek (f , 0 , SEEK_END); 
        size = ftell(f); 
        rewind (f); 
         
        printf("\nTotal bytes to write : %d\n", size);
        
        lob = OCI_LobCreate(cn, OCI_BLOB);
        
        OCI_Prepare(st, "insert into my_blob_table(code, content) values (1, :data)");
        OCI_BindLob(st, ":data", lob);
        OCI_Execute(st);
   
        /* write data into table by chunks of 1024 bytes */ 
        while ((n = fread(buffer, 1, sizeof(buffer), f)))
        {
            OCI_LobWrite(lg, buffer, n);
        }
   
        printf("\nTotal bytes written : %s\n", OCI_LobGetLenght(lob));
        fclose(f);
   
        OCI_Commit(cn);
   
        OCI_LobFree(lob);
    }
   
    /* ... */
    

    
    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;
    OCI_Lob *lob;
    FILE *f;
    char buffer[128];
   
    /* ... */
   
    st = OCI_CreateStatement(cn);
   
    OCI_ExecuteStmt(st, "select content from my_blob_table where code = 1");
   
    rs = OCI_GetResultset(st);
   
    while (OCI_FetchNext(rs))
    {
        lob = OCI_GetLob(rs, 1);
      
        /* read data from table by chunks of 128 bytes */ 
        while ((n = OCI_LobRead(lob, buffer, sizeof(buffer)-1))
        {
            buffer[n] = 0;
            printf("%s\n", buffer);
        }
    }
   
    /* ... */
    

      
    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;
    OCI_File *file;
    unsigned char buffer[1024];
    int n;
   
    /* ... */
   
    st = OCI_CreateStatement(cn);
   
    OCI_ExecuteStmt(st, "select value from my_bfile_table where code = 1");
   
    rs = OCI_GetResultset(st);
   
    while (OCI_FetchNext(rs))
    {
        file = OCI_GetFile(rs, 1);
   
        OCI_FileOpen(file);
   
        printf("file size %d\n", OCI_FileGetSize(file));
        printf("file dir  %s\n", OCI_FileGetDirectory(file));
        printf("file name %s\n", OCI_FileGetName(file));
   
        while (n = OCI_FileRead(file, buffer, sizeof(buffer))
        { 
        	/* faire ce l'on veut du contenu ... */
        }
   
        OCI_FileClose(file);
    }
   
    /* ... */

    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;
    OCI_Long *lg;
    unsigned char buffer[1024];
    FILE *f;
    int n;
   
    /* .... */
   
    st = OCI_CreateStatement(cn);
   
    /* stockage du fichier dans la DB */
   
    f = fopen("file name", "rb");
   
    if (f != NULL)
    {
        fseek (f , 0 , SEEK_END); 
        n = ftell(f); 
        rewind (f); 
   
        printf("\n%d bytes to write\n", n);
   
        lg = OCI_LongCreate(st, OCI_BLONG);
   
        OCI_Prepare(st, "insert into test_long_raw(code, content) values (1, :data)");
        OCI_BindLong(st, ":data", lg, n);
        OCI_Execute(st);
   
        /* write data into table by chunks of 1024 bytes */ 
        while ((n = fread(buffer, 1, sizeof(buffer), f)))
        {
            OCI_LongWrite(lg, buffer, n);
        }
   
        printf("\n%d bytes written\n", OCI_LongGetSize(lg));
        fclose(f);
   
        OCI_Commit(cn);
   
        OCI_LongFree(lg);
    }
   
    /* récupération des données depuis la DB */
   
    OCI_ExecuteStmt(st, "select content from test_long_raw where code = 1");
    OCI_SetLongMaxSize(st, 100000);
   
    rs = OCI_GetResultset(st);
   
    /* read data by chunks of 1024 bytes*/ 
    while (OCI_FetchNext(rs))
    {
        lg = OCI_GetLong(rs, 1);
   
        while ((n = OCI_LongRead(lg, buffer, sizeof(buffer))))
        {
            /* faire ce que l'on veut des données */ 
        }
   
        printf("\n%d bytes read\n", OCI_LongGetSize(lg));
    }
   
    /* .... */
    

create type t_produit as object 
(
    code       number,
    libelle    varchar2(30),
    prix       number(5,3),
    reference  varchar2(100) 
);

create table ventes_produits
(
 	product    t_produit,
 	nombre     int,
 	date_vente date
);

    
    OCI_Connection *cn;
    OCI_Statement *st; 
    OCI_Object *prod;
    OCI_Date *date;
    int qte;
    
    /* ... */
   
    prod = OCI_ObjectCreate(cn, OCI_SchemaGet(cn, "t_product", OCI_SCHEMA_TYPE);
    date = OCI_DateCreate(cn);
    
    qte = 356;
    OCI_DateSysDate(date);
    
    OCI_ObjectSetInt(prod, "CODE", 1);
    OCI_ObjectSetString(prod, "LIBELLE", "USB KEY 2go");
    OCI_ObjectSetDouble(prod, "PRIX", 12.99);
    OCI_ObjectSetString(prod, "REFERENCE", "A56547WSAA");

    OCI_Prepare(st, "insert into ventes_produits values(:p, :n, :d)");
    
    OCI_BindObject(st, ":p", prod);
    OCI_BindInt(st, ":n", &qte);
    OCI_BindDate(st, ":d", date);
   
    OCI_Execute(st);

    printf("\n%d row(s) inserted\n", OCI_GetAffectedRows(st));

    OCI_Commit(cn);

    OCI_ObjectFree(obj);
   
    /* ... */

    OCI_Connection *cn;
    OCI_Statement *st; 
    OCI_Resultset *rs; 
    OCI_Object *prod;
    OCI_Date *date;
    int qte;
    
    /* ... */
   
    OCI_ExecuteStmt(st, "select * from ventes_produits");
  
    rs = OCI_GetResultset(st);
   
    while (OCI_FetchNext(rs))
    {
        prod = OCI_GetObject(rs, 1);
        qte  = OCI_GeInt(rs, 2);
        date = OCI_GetDate(rs, 3);
   
        printf("Produit : %s, Ventes : %i\n", OCI_ObjectGetString(prod, "LIBELLE"), qte);
    }   
    
    /* ... */

    OCI_Statement *st;
    OCI_Resultet *st;
    OCI_Date *dt;
    char str[100];
   
    /* ... */
   
    st = OCI_CreateStatement(cn);
   
    OCI_ExecuteStmt(st, "select mon_champs_date from my_table");
    rs = OCI_GetResultset(st);
   
    while (OCI_FetchNext(rs))
    {
        dt = OCI_GetDate(rs, 1);
   
        OCI_DateToText(dt, "DD/MM/YYYY HH24:MI:SS", sizeof(str)-1, str);
        printf("Date is %s\n", str);
   
        OCI_DateAddDays(dt, 5);
        OCI_DateAddMonths(dt, 2);
   
        OCI_DateToText(dt, "DD/MM/YYYY HH24:MI:SS", sizeof(str)-1, str);
        printf("Date + 5 days and 2 months is %s\n", str);
    }
   

    OCI_Statement *st;
    OCI_Timestamp *tm;
    char str[100];
   
    /* ... */
   
    st = OCI_CreateStatement(cn);
   
    OCI_ExecuteStmt(st, "SELECT CURRENT_TIMESTAMP FROM dual");
    rs = OCI_GetResultset(st);
   
    OCI_FetchNext(rs);
    tm = OCI_GetTimestamp(rs, 1);
   
    OCI_TimestampToText(tm, "DD/MM/YYYY HH24:MI:SS:FF3\n", 100, str, 3);
    printf(str);
    

    
    OCI_Connection *cn;
    OCI_Timestamp *tm;
    OCI_Interval *itv;
    char str[100];
   
    /* ...