Re: OCI Example?

In article <1993Mar10.111209.20858_at_kaija.spb.su> adn_at_kaija.spb.su (ADN communication group) writes:
>Does anybody have an OCI examlple (similar to Pro*C one) to
>executing dynamic queries??

Posting this because several people have asked about it privately...

The ORACLE7 OCI manual has a sample program, called cdemo2.c, that does complete dynamic SQL, just like the sample program in the Pro*C supplement. This program can be easily made to work with V6--you'll have to change OPARSEs to OSQL3, and use ODSC instead of ODESCR (most users).

**OPINION ALERT** This kind of thing is both conceptually and programmatically easier with the OCI than with Pro*C.

Current Precompiler dynamic SQL is somewhat limited by the ANSI SQL89 specs (my opinion, not Oracle's), so an OCI program doing dynamic queries can be more straightforward. Precompiler dynamic SQL should be much neater with full ANSI/ISO SQL92.

**END** --Tim (tssmith_at_netcom.com) (tssmith_at_oracle.com) Received on Thu Mar 11 1993 - 07:49:00 CET