Re: Q: eXt. Procs. - callbacks

tkyte_at_us.oracle.com (Thomas Kyte) writes:
>
> OCI is the Oracle Call Interface, this is the lowest level interface
> you as a programmer can code to directly. It is layered on top of
> Oracle's internal API called UPI/OPI. If you want to code natively
> in C with no pre-processor, this is what you would use.
>
> The precompiler folks have their own (undocumented) API called SQLLIB.
> You cannot code to SQLLIB yourself. SQLLIB is a layer on top of
> UPI/OPI. It is what pro*c and the other precompilers "precompile"
> into. You cannot code (nor would there be any good reason to)
> directly to SQLLIB. If you want to code directly to an API, you would
> use the documented and supported OCI layer.
>

This is very interesting. I was not aware that what Pro*C generates is _not_ OCI. I started programming in Pro*C because I was able to get started rather quickly. So, is it better to use Pro*C or OCI when it comes to performance, portability, and development time?

--
David F. Newman
Oracle DBA
buzzwang_at_ourvillage.com Received on Thu Aug 05 1999 - 21:04:07 CDT