René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Describing a select list with adpoci [adpoci example]

Here's an OCI programm that describes an select *.
This programm needs adpoci to be linked.
Be sure to first compile and link the library into a shared library or dll.
After doing so, the programm can be compiled and linked like so
On Linux with gcc: 
gcc -I$ORACLE_HOME/rdbms/demo -I$ORACLE_HOME/rdbms/public describe_table.c -o describe_table -L. -L$ORACLE_HOME/lib -ladpoci -lclntsh
On Windows with mingw: 
gcc -Wall -I%ORACLE_HOME%/oci/include describe_table.c adpoci.dll %ORACLE_HOME%/bin/oci.dll -o describe_table.exe
With cygwin: 
gcc -I$ORACLE_HOME/oci/include -I../adpoci/ describe_table.c -o describe_table -L../adpoci -L$ORACLE_HOME/lib -ladpoci $ORACLE_HOME/bin/oci.dll -mno-cygwin

Usage

./describe_table username/password@db

describe_table.c

describe_table.c
#include <stdio.h>
#include <stdlib.h>

#include "adpoci.h"

int main(int argc, char* argv[]) {
         char err_msg   [512];
         //sword          r;
  struct oci_connection conn;
         OCIStmt*       sh; 
         int            pos;
  struct oci_description    descr;

  //int numCol;

  if (argc < 2) {
    printf("usage %s username/password[@dbname]\n", argv[0]);
    exit (-1);
  }

  text  username[30];
  text  password[30];
  text  dbname  [30];

  parse_connect_string(argv[1],username, password, dbname);

  if (!oci_connect(username, password, dbname, &conn, err_msg)) {
    printf("Error with oci_connect: %s\n",err_msg);
    goto clean_up;
  }

  if (! (sh=oci_parse("select * from oci_test_table", err_msg, &conn))) {
    printf(err_msg);
    goto clean_up;
  }

  if (! oci_execute0(sh, err_msg, &conn)) {
    printf("after x\n");
    printf(err_msg);
    goto clean_up;
  }

  //OCIAttrGet(sh, OCI_HTYPE_STMT, &numCol, 0, OCI_ATTR_PARAM_COUNT, conn.err);
  //printf("Nof: %d\n", numCol);

  pos = 1;
  while (oci_describe(sh, err_msg, &conn, &descr, pos)) {
    printf("%-30s %d:\n", descr.col_name, descr.col_type) ;
    pos++;
  }

clean_up:

  OCITerminate(OCI_DEFAULT);

  return 0;
}