I have two nested queries and one nested stored procedure call. I couldn't get resluts from the stored procedure. Cocoon says: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.ClassCastException: oracle.jdbc.driver.OraclePreparedStatement
here's a fragment of XSP. <esql:execute-query> <esql:query> select ... </esql:query> <esql:results> <rowset name="quals"> <esql:row-results> <row> <esql:get-columns/> <esql:execute-query> <esql:call needs-query="true" > {call PKG_STUDENT.STUD_QUAL_STATUS( <esql:parameter direction="in" type="string"><esql:get-string ancestor="2" column="ID"/></esql:parameter>, <esql:parameter direction="in" type="string"><esql:get-string ancestor="1" column="qual_id"/></esql:parameter>, <esql:parameter direction="out" type="String"/>, <esql:parameter direction="out" type="date"/>, <esql:parameter direction="out" type="Int"/>)} </esql:call> <esql:call-results> <esql:results> <esql:result><xsp:expr>(ResultSet)<esql:get-object column="2" from-call="true" /></xsp:expr></esql:result> <esql:row-results> <status><esql:get-string column="3"/></status> <remdays><esql:get-int column="5"/></remdays> </esql:row-results> </esql:results> </esql:call-results> </esql:execute-query> </row> </esql:row-results> </rowset> </esql:results> </esql:execute-query> I couldn't get what's wrong. Thanks Argyn stack trace: ========================================= Original exception : java.lang.ClassCastException: oracle.jdbc.driver.OraclePreparedStatement at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.getCallableStatem ent(EsqlQuery.java:194) at org.apache.cocoon.www.docs.samples.xsp.studentdata_xsp.generate(C:\JBoss-2.4 .1_Tomcat-3.2.3\tomcat\work\localhost_8080%2Fargyn\cocoon-files\org/apache/c ocoon/www/docs/samples/xsp\studentdata_xsp.java:820) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera tor.java:260) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv entPipeline.java:251) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS treamPipeline.java:399) at org.apache.cocoon.www.sitemap_xmap.matchN1057A(C:\JBoss-2.4.1_Tomcat-3.2.3\t omcat\work\localhost_8080%2Fargyn\cocoon-files\org/apache/cocoon/www\sitemap _xmap.java:7078) at org.apache.cocoon.www.sitemap_xmap.process(C:\JBoss-2.4.1_Tomcat-3.2.3\tomca t\work\localhost_8080%2Fargyn\cocoon-files\org/apache/cocoon/www\sitemap_xma p.java:3056) at org.apache.cocoon.www.sitemap_xmap.process(C:\JBoss-2.4.1_Tomcat-3.2.3\tomca t\work\localhost_8080%2Fargyn\cocoon-files\org/apache/cocoon/www\sitemap_xma p.java:2519) at org.apache.cocoon.sitemap.Handler.process(Handler.java:222) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154) at org.apache.cocoon.Cocoon.process(Cocoon.java:575) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:983) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 2) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) at java.lang.Thread.run(Unknown Source) ==================================== --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>