DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=30894>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=30894 SQLTransformer doesn't support SPs that return a result set Summary: SQLTransformer doesn't support SPs that return a result set Product: Cocoon 2 Version: 2.1.5 Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Normal Priority: Other Component: blocks AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I'm using the SQLTransformer to call a Sybase stored procedure that returns a result set; I'm not using any output parameters. However, when I get the results back from transformer, all it contains is <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd";> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <accountdetails> <rowset xmlns="http://apache.org/cocoon/SQL/2.0"/> </accountdetails> </page> Looking through Query.serializeStoredProcedure(ServiceManager manager) (SQLTransformer.java lines 1271-1323), it seems to me that when isstoredprocedure="true" it only handles output that is returned in outParameters. Any result sets are not processed, other than those which happen to be returned in an output parameter (which Oracle obviously supports, judging by the SQLTransformer documentation, but I don't know if any other DBMSs do).
