ESQl and Stored Procedures

[Carlos Dias]

Hi, I'm trying to use a stored procedure for making an update in an Oracle database. Here is the xsp+esql code: <?xml version="1.0" encoding="iso-8859-1"?>   <xsp:page  language="java"  xmlns:xsp="http://apache.org/xsp"  xmlns:xsp-request="http://apache.org/xsp/request/2.0"  xmlns:esql="http://apache.org/cocoon/SQL/v2">    <xsp:structure>   <xsp:include>java.lang.String</xsp:include>  </xsp:structure>    <update>   <esql:connection>    <esql:pool>sca</esql:pool>    <xsp:logic>         String   app_id                   = request.getParameter("app_id");     String   user_id                  = request.getParameter("user_id");     if (app_id != null || user_id != null) {          <esql:call>       {call bookmark.update_bookmark_list(<esql:parameter direction="in" type="String">\                <xsp:expr>user_id</xsp:expr></esql:parameter>,\                <esql:parameter direction="in" type="String">\                <xsp:expr>app_id</xsp:expr></esql:parameter>)}      </esql:call>      <esql:call-results>      <esql:update-results>       <number-of-rows><esql:get-update-count/></number-of-rows>      </esql:update-results>      </esql:call-results>     }     else {      <exception>Parameters does not exists</exception>     }      </xsp:logic>   </esql:connection>  </update> </xsp:page>   I got the following result (in the web page): XML document must have a top level element. Error processing resource 'http://rasputin:9090/adslV3/cubenavigator/update_bookmark'. In the error.log: [core.program-generator] (/adslV3/cubenavigator/update_bookmark) http9090-Processor7/ProgramGeneratorImpl: The serverpage [file:/home/cdias/altaia/tomcat/webapps/adslV3/cubenavigator/generators/dynamic/xsp/update_bookmark_list.xsp] could not be preloaded, will be re-created (org.apache.cocoon.components.language.LanguageException: Unable to preload program org/apache/cocoon/www/cubenavigator/generators/dynamic/xsp/update_bookmark_list_xsp: org.apache.cocoon.components.language.LanguageException: Could not load class for program 'org/apache/cocoon/www/cubenavigator/generators/dynamic/xsp/update_bookmark_list_xsp' due to a java.lang.ClassNotFoundException: org.apache.cocoon.www.cubenavigator.generators.dynamic.xsp.update_bookmark_list_xsp)   Can anybody tell me what's going on?!   Thanks in advance, Carlos Dias