How to run Oracle SQL statement in C program?

[suhaimi]

Hi all,
I would like to read each record from a ORACLE database using SQL and output each of the records into different output files. How do I do this in C program???

Thanks in advance,
Suhaimi

 

[hoinz]

You will have to use Oracle's Pro*C precompiler.

 

[columb]

You need to use Oracle ProC which comes with Oracle (well, it does with ours, but I don't do the purchasing!) Oracle ProC is a massive product which allows full integration of Oracle a 'C' and is far too detailed to be dealt with here.

Alternatively....
You could use system calls to run SQL in a shell. This leaves the problem of accessing the output of the commands. See a recent thread about running DOS commands within 'C' for more on this.

 

[fl0ra]

or...
you can use Tcl/Tk extension for C (it is free)
and use nstcl on top of that (free)

http://nstcl.sourceforge.net/

or Oratcl (free as well)

http://oratcl.sourceforge.net/

Go on the Tcl/Tk forum if you need any help with that.

 

[dsanchez2]

You could also use ORACLE's OCI (Oracle's Call Interface). This is an API into Oracle. This library provides a set of routines to execute SQL Statements and retrive the result sets. The ProC pre-processor generates calls to these routines.

This library is provided with Oracle.

 

[xwb]

If you want to use C++, OTL provides quite a nice interface.

http://otl.sourceforge.net/