I'd like to access an Oracle 8i running on Linux using Allegro Common
Lisp (the Linux trial edition).
Is there a ffi to the Oracle Call Interface available, or do I have to
use ODBC?
--
Lars
Lars Bj�nnes <············@fredrikstad.online.no> writes:
> Is there a ffi to the Oracle Call Interface available, or do I have to
> use ODBC?
AFAIK, your only out-of-the-box solution is Allegro ODBC (but we didn't
want to use ODBC and rolled our own intermediate server instead).
--
(espen)
Espen Vestre <·····@*do-not-spam-me*.vestre.net> writes:
> Lars Bj�nnes <············@fredrikstad.online.no> writes:
>
> > Is there a ffi to the Oracle Call Interface available, or do I have to
> > use ODBC?
>
> AFAIK, your only out-of-the-box solution is Allegro ODBC (but we didn't
> want to use ODBC and rolled our own intermediate server instead).
Hm. Did you base your server on some existing (available :-) code
or did you write it from scratch?
--
Lars
A colleague and I implemented an FFI to Oracle OCI from an old version of
what was then Lucid Common Lisp (in about 1990). It was relatively
straightforward, except in error handling, for which a reasonably uniform
solution was possible, and signal handling, which required some careful (but
uniform) coding on every transition from Lisp to C and back again (if any C
code called lisp functions). The basic idea was that that old version of
the OCI set up certain signal handlers when a connection was established.
These had to be in place for all calls on that connection. But Lisp had its
own signal handlers that were required, so at the FFI transitions, the sets
of handlers had to be swapped.
Jeff
Christopher C Stacy <······@world.std.com> writes:
> You could implement OCI in Lisp; the source code for Paul Meurer's ODBC/SQL
> package might prove very useful as starting point.
Thanks, I'll take a look.
Where's Meurer's ODBC/SQL-package located, and what's the latest
version? (I can't seem to find the official pick-up point.)
--
Lars
"Lars Bj�nnes" wrote:
> Where's Meurer's ODBC/SQL-package located, and what's the latest
> version? (I can't seem to find the official pick-up point.)
Rainer mentioned it is also distributed with CL-HTTP.
Robert
Lars Bj�nnes <············@fredrikstad.online.no> writes:
> Christopher C Stacy <······@world.std.com> writes:
>
> > You could implement OCI in Lisp; the source code for Paul Meurer's ODBC/SQL
> > package might prove very useful as starting point.
>
> Thanks, I'll take a look.
>
> Where's Meurer's ODBC/SQL-package located, and what's the latest
> version? (I can't seem to find the official pick-up point.)
ftp://amirani.hit.uib.no/sql-odbc/
--
------------------------------------------------------------------
Stig Erik Sandoe ····@ii.uib.no http://www.ii.uib.no/~stig/
On 30 Jan 2000 22:34:20 +0100, ····@ii.uib.no (Stig Sand�) wrote:
>Lars Bj�nnes <············@fredrikstad.online.no> writes:
>
>> Christopher C Stacy <······@world.std.com> writes:
>> [...]
>> Where's Meurer's ODBC/SQL-package located, and what's the latest
>> version? (I can't seem to find the official pick-up point.)
>
>ftp://amirani.hit.uib.no/sql-odbc/
>
>
Yes, that's the "official" pick-up point. The version is now 0.85. I
neglected to announce the new release, but it contains only some minor
fixes and enhancements (see the release notes).
- paul
____________________________________________
Paul Meurer at HIT UiB no
Humanities Information Technologies Centre,
University of Bergen
All�gaten 27, 5007 Bergen
Norway
Hello,
"Lars Bj�nnes" wrote:
>
> Christopher C Stacy <······@world.std.com> writes:
>
> > You could implement OCI in Lisp; the source code for Paul Meurer's ODBC/SQL
> > package might prove very useful as starting point.
>
> Thanks, I'll take a look.
>
> Where's Meurer's ODBC/SQL-package located, and what's the latest
> version? (I can't seem to find the official pick-up point.)
It should be on the FTP server of Digitool (ftp://ftp.digitool.com/).
That's were I found it.
Works great, has some very nice general foreign function layer (I have
used it to do a somewhat buggy port to ACL3WIN some times ago) and the
rest of the code is easy to read so you can bring in your own functions.
It would be nice to hear from your results, this may be interesting to
see what you can do with a native interface to a database more than you
could do with SQL and ODBC.
Bye
Joe
--
Johannes Beck beck at informatik.uni-wuerzburg.de
Lars Bj�nnes <············@fredrikstad.online.no> writes:
> Hm. Did you base your server on some existing (available :-) code
> or did you write it from scratch?
It was written pretty much from scratch.
--
(espen)