Oracle

[mikebw at colossus.bilow.com (Mike Bilow)]

You have pretty much two options.

One is to use Embedded SQL, which is a sort of extended syntax for C-like
programming languages which allows you to generate SQL queries and receive
result sets.  This technique is usually implemented by using macro
preprocessing, but not always.  The advantage of Embedded SQL is that
there is a more-or-less ANSI-standard syntax for it which, if proprietary
extensions are avoided, should be vendor-independent as far as servers.

Oracle defines a proprietary system called PL/SQL, where "PL" stands for
"Procedural Language."  This allows working in a more traditional way from
C-like languages, rather than structuring the code around queries.  Of
course, this approach is highly specific to Oracle.

Just out of curiosity, if you are using Linux, why choose Oracle?

See http://www.inquiry.com/techtips/thesqlpro/ for more information.

-- Mike


On 2000-05-10 at 10:40 -0400, Frank Ramsay wrote:

> This is kind of OT, but I figure someone here will know.
> I have a C++ program that needs to interface with Oracle.  Does 
> anyone know of a C or C++ toolkit for connecting to Oracle?
> I'd prefer something that works like perl/DBI so I have the 
> option to easily switch to other back end SQL databases.
> The toolkit will need to work on Linux and AIX.


-
Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at blu.org (Subject line is ignored).