On Tuesday 26 August 2003 05:41 pm, Dossy wrote: > On 2003.08.26, Roberto Mello <[EMAIL PROTECTED]> wrote: > > OpenACS and its database API (which builds upon AOLserver's API) has code > > to do that, including returning a list of ns_sets. > > > > http://openacs.org/api-doc/proc-view?proc=db%5flist%5fof%5fns%5fsets > > I looked at nsoracle 2.6 and it doesn't seem to have any support for > REF CURSORs ... what Oracle driver is OpenACS using? The docs at the > URL you provided don't mention supporting the "sql" parameter being a > stored proc exec, but it doesn't mention it not supporting it, either.
The driver doesn't handle cursors but doesn't Oracle 9i allow for PL/SQL functions that return rowsets? The driver should be able to handle that case fine. -- 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.
