Click here to Skip to main content
Click here to Skip to main content

C++ wrapper for Oracle's OCI Interface

, 27 Sep 2002
Rate this:
Please Sign up or sign in to vote.
This article will provide a cross platform C++ wrapper for Oracle's OCI interface.

Introduction

With this C++ wrapper, you can easily do the following:

  • Connect/disconnect to an Oracle server;
  • Execute SQL select/insert/update/delete commands;
  • Store the query result in a simple linked list;

This project is a cross platform implementation.

class  ObList ;
class  Record ;
class  RecordSet;
int Connect();
int Connect(char *user, char *pass, char *service);
void DisConnect();
int ExecCommand(char* cmdbuf);

Examples:

#include <stdio.h>
#include "dbclient.h"

int main(int argc, char* argv[])
{
    Connect();

    printf("Connect OK.\n");
    RecordSet set;
    set.Open("select * from EMP");
    for(int k=0;k<set.GetRecordsCount();k++)
    {
        Record *pRec=set.GetRecord(k);
        for(int l=0;l<pRec->GetFieldsCount();l++)
        {
            printf("%s",pRec->GetFieldValue(l));
            if(l==(pRec->GetFieldsCount()-1))
                printf("\n");
            else
                printf("\t");
        }
    }
    DisConnect();
    return 0;
}

If you are interested in this article, and want to get details, contact me at lihaijian@sina.com or ema13@dongfang-china.com.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

lihaijian
Web Developer
United States United States
6 years Programer With VC++

Comments and Discussions

 
Questionlinking error :( Pinmembersu_r00t5-Feb-09 5:19 
Generalmy email had changed!w Pinmemberyt_lhj29-Apr-08 21:41 
QuestionRe: insert? Pinmemberzuzulica3-Jan-07 11:03 
Questioninsert? Pinmembercata_100024-Nov-06 10:57 
GeneralORACLE/ODBC PinmemberM_Nuaimi25-Apr-06 13:23 
GeneralOracle OCI library Pinmembermaacha13-Apr-05 18:00 
GeneralRe: Oracle OCI library PinmemberMichael B Pliam22-Feb-07 20:34 
GeneralCLOB Datatype PinmemberLeong Hoe Wai18-Aug-04 19:26 
Questionhow i can do insert? Pinmemberandresfecas26-Apr-04 14:03 
GeneralUnable to link OCI containing library PinmemberVijaylakshmi18-May-03 19:10 
GeneralRe: Unable to link OCI containing library PinmemberThoMay2-Mar-05 19:16 
Generalmemory bug in source code Pinmemberscy1-Mar-03 0:33 
GeneralRe: memory bug in source code Pinmemberscy6-Jan-04 14:51 
GeneralA simple linklist; PinmemberMadmaximus16-Dec-02 4:38 
GeneralRe: A simple linklist; Pinmemberyt_lhj16-Dec-02 18:14 
QuestionHow can I do ?? PinsussShanGuohui24-Oct-02 3:11 
QuestionHow do you handle two connections ? PinmemberMiroslav Rajcic29-Sep-02 21:03 
AnswerRe: How do you handle two connections ? Pinmemberlihaijian29-Sep-02 21:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 28 Sep 2002
Article Copyright 2002 by lihaijian
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid