I have been working on an enhanced SQL extension for Xalan-J. This adds support for callable statements, multiple result sets, and output parameters. To do this it makes some changes from the syntax of the existing SQL extension. Most significantly to support multiple result sets, the metadata element is made a child of the row-set element. There are also changes to the call syntax. Parameters (input and output) are passed via variables.
I would like to contribute this enhanced SQL to the Xalan project. Is there interest in this contribution? Since this changes the sql extension syntax, should I package this as an alternative function, cquery() for example, or just replace query() and pquery() with a new query()? Note that the new function and be used to do everything that query() and pquery() currently do (with different syntax) as well as the new functionality. In short, if the query has parameter definitions then they are used, if it starts with "CALL" (perhaps after a return parameter definition) then it is assumed to be a CallableStatement.
The current status of this is that it has had only limited testing - but seems to be working. There are some details that need to be cleaned up, some debugging stuff to be deleted, etc. This could be submitted fairly soon (unless further testing uncovers something).
Thank You,
Art
