I have a question regarding support for Oracle 9i in AOLserver. I'am currently using AOLserver v. 3.4 and v. 2.5 of the oracle driver originally distributed by ArsDigita accessing an Oracle 8.1.7 database. My question is whether I can upgrade Oracle to 9i and still use AOLserver and the Oracle driver?
I have been browsing serveral forums here at OpenACS, Google and AOLserver.com looking for information about AOLserver accessing Oracle 9i. I understand that the OpenACS source code does not work with Oracle 9i, but I can't figure out whether the Oracle driver works with Oracle 9i. It seems that the latest version is 2.6 (found in the AOLserver CVS repository) and that it was released before Oracle 9i. I have read a few recent postings about the driver here at OpenACS and it seems that the Oracle driver has only been in the AOLserver CVS repository (at SourceForge) for a few month.
It is not a problem for me that the OpenACS code does not work with Oracle 9i, because my focus is very different. I'am a co-developer of SMLserver (www.smlserver.org) which is basically a plugin to AOLserver that makes it possible to script with Standard ML instead of Tcl, and we are facing two problems:
1) we would like to support Oracle 9i. Is this really a problem?
2) we would like to support bind-variables, clobs and function calls to Pl/SQL which are not supported by the AOLserver DB API. This means that we must extend the driver code in order to support these functionalities in Standard ML - in the same way that the current driver support these functionalities in special Tcl-functions. This raises my next question: What version of the driver should we base our implementation on (I guess the answer i v. 2.6)?
Even though that I'am not asking a question directly related to OpenACS (which by the way is a very impressive system), I know that you have a huge knowledge base about these issues and hope that you will respond to my question
Niels Hallenberg (firstname.lastname@example.org)