On Mon, 29 Nov 2004 13:26:15 -0800, John M McIntosh


<johnmci at smalltalkconsulting.com> wrote:
> If you dig around you'll find the Oracle Call Interface is documented
> by Oracle
> in one of their publications. This is what VW uses at the lowest level.
> It's straight C code
> binding to atomic values or arrays. This could easily be done in FFI.
>
> mmm let's see
> http://www.csee.umbc.edu/help/oracle8/server.815/a67846/toc.htm

Hmm... but concurrent calls may still be a problem.  Good news: their
non-blocking interface uses polling rather than callbacks (so would
work with FFI).  Bad news:

" While waiting to retry non-blocking OCI call, the application may
not issue any other OCI calls, or an ORA-03124 error will occur. The
only exceptions to this rule are OCIBreak() and OCIReset(). See
"Cancelling a Non-blocking Call" for more information on these calls.
".

So, you won't block the whole VM, but your Oracle queries will be
strictly serialized.

Avi