On Mon, Apr 26, 2004 at 06:55:58PM +0100, Stuart Children wrote:

> After that it's investigating the TCL API in a bit more depth,
> specifically looking at more complex database issues (playing with ref
> cursors, stored procedures, etc). Probably lots more, but that's for

AFAIK, working ref cursor support has been hacked into the Oracle
driver at least twice by different people, but isn't currently
supported in nsoracle 2.7 (the latest stable version).  I think it's
one the things Jeremy Collins is planning to add, though:

  http://www.tclsource.org/oracle/

(I think the PostgreSQL driver neither ref curors nor has them,
because PostgreSQL has something better.  All the other databases and
their drivers, I've no idea.)

If you haven't already, you should look at the OpenACS db API for your
Oracle work, as it is nice, and noticeably higher level than the
AOLserver ns_db API (which it is built upon).  Unfortunately it is not
set up for easy re-use outside of an OpenACS environment, but it is
not too hard to hack it into working without OpenACS if that's what
you really want.

--
Andrew Piskorski <[EMAIL PROTECTED]>
http://www.piskorski.com/


--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of 
your email blank.

Reply via email to