Re: Embedded SQL vs OCI
From: Mike Eggleston <mikee_at_orca.aadt.com>
Date: Wed, 2 Feb 1994 19:08:40 GMT
Message-ID: <MIKEE.94Feb2130840_at_orca.aadt.com>
Date: Wed, 2 Feb 1994 19:08:40 GMT
Message-ID: <MIKEE.94Feb2130840_at_orca.aadt.com>
>>>>> "Darin" == Darin McBeath <darin_at_meaddata.com> writes: In article <2ioepe$ke3_at_meaddata.meaddata.com> darin_at_meaddata.com (Darin McBeath) writes:
> I am beginning to write applications in Oracle and have a very
> simple question. In terms of performance, is it better to write a C
> application in embedded SQL or OCI.
The OCI interfaces offer a lot of advantage over ESQL.
- easier to debug the code
- don't have to look at generated, embedded code
- strings are null terminated in OCI but not in ESQL
- you should be able to generate better OCI code than the preprocessor -- -- Mike Eggleston American Airlines Decision Technologies (817)931-2287 P. O. Box 619616, MD 4462 (817)967-9763 (FAX) Dallas/Fort Worth Airport, Texas 75261-9616, USA Only my opinions.