Oracle Call Interface Classes

Examples

extern "C"{
#include <ociapr.h>
}
#include <iostream.h>
#include <string.h>
#include <ctype.h>
#include <stdarg.h>
#include "OciClassDef.h"
#include "OciException.h"
#include "OciVariable.h"
#include "OciDatabase.h"
#include "OciCursor.h"

void SelectMethod1( COciDatabase& db )
{
   COciCursor     cur( db );
   int            empno;
   char           empname[32];

   // parse SQL statement
   cur.Parse("SELECT empno, ename FROM EMP");
   // bind 1st column in select list
   cur.BindInt( 1, &empno );             
   // bind 2nd column in select list
   cur.BindCString( 2, empname, 32 );    
   // execute SQL statement
   cur.Exec();
   // fetch until there are no more records
   while ( cur.Fetch() )
   {
      cout << empno << endl;
      cout << empname << endl;
   }
}

void SelectMethod2( COciDatabase& db )
{
   COciCursor           cur( db );
   COciInt              empno( 1 );    // 1st column in select list 
   COciString<32>       empname( 2 );  // 2nd column in select list

   cur.Parse("SELECT empno, ename FROM EMP");

   cur.Bind( empno );
   cur.Bind( empname );

   cur.Exec();

   while ( cur.Fetch() )
   {
      cout << empno << endl;
      cout << empname << endl;
   }
}

void SelectMethod3( COciDatabase& db )
{
   COciCursor           cur( db );
   COciString<100>      empname;
   COciDate             empdate;

   cur.Eexec("SELECT ename, hiredate FROM EMP", &empname, &empdate, NULL );

   while ( cur.Fetch() )
   {
      cout << empname << endl;
      cout << empdate.GetYear() << empdate.GetMonth() << empdate.GetDay() << endl;
   }
}

void UpdateMethod1( COciDatabase& db )
{
   COciCursor           cur( db );
   // if you use in the constructor a string the variable will be marked as
   // placeholder rather then bind variable
   COciString<7>        empsalary(":salary");
   COciString<9>        empjob(":ejob");

   empsalary = "21000";
   empjob = "SwEng";

   cur.Eexec("UPDATE EMP SET sal = :salary, job = :ejob WHERE  ename='SCOTT'", &empsalary, &empjob, NULL );

   db.Commit();
}


void DescrMethod1( COciDatabase& db )
{
   COciCursor        cur( db );
   COciColumnDesc    coldesc;

   cur.Parse("SELECT * FROM EMP");

   int Index = 1;
   do
   {
      cur.DescribeColumn( Index, coldesc );
      Index++;
   } while ( !cur.EndOfDesc() );
}

void main( void )
{   
   COciDatabase   db;   
   try   
   {
      db.Connect("scott/tiger@mauro.world");
      cout << "\\nSelectMethod1:\\n";      
      SelectMethod1( db );
      cout << "\\nSelectMethod2:\\n";      
      SelectMethod2( db );
      cout << "\\nSelectMethod3:\\n";      
      SelectMethod3( db );
      cout << "\\nUpdateMethod1:\\n";      
      UpdateMethod1( db );
      cout << "\\nDescrMethod1:\\n";      
      DescrMethod1( db );     
   }
   catch( COciException& pErr )   
   {
      // print out error message
      cerr < pErr.m_Message < endl;    
   }
}

Thanks to my friend Abbondio Vago for is usefull work to create this library.

Downloads