Re: Alternate for ESQL

In article <3mh7k7$bo4_at_Venus.mcs.com> oddsock_at_MCS.COM (Ed Zaleski) writes:

> I am looking at what it would take to create an application level API for Oracle so
> that all the C programs that we plan to write, which will need to send SQL stmts
> (also DECLAREs, etc..) to our Oracle DB.

I rolled my own interface in C++, creating a query class that's used as follows:

    int x, y;

    query q1 = "insert into tablename (x, y) values (#, #)";     q1 << x << y;

    query q2 = "select x, y from tablename";     while(q2.more()) {

      q2 >> x >> y;
    }      

(If I were doing it again, though, I'd change the interface to eliminate the # placeholders.)
It took about 8k of source.

Tim Boemker
Optimum Group
(513) 577-7785 Received on Thu Apr 13 1995 - 00:00:00 CEST