OK, once again. Here is actual code: <esql:execute-query> <esql:call>{call cocoon_proc(<esql:parameter direction="inout" type="String">'123'</esql:parameter>)} </esql:call> <esql:call-results> <esql:results> <esql:result><esql:get-string column="1" from-call="true"/></esql:result> </esql:results> </esql:call-results> </esql:execute-query>
returns: org.apache.cocoon.ProcessingException: Language Exception: org.apache.cocoon.components.language.LanguageException: Error compiling Merci_Dics_xsp: Line 451, column -1: inconvertible types Line 0, column 0: Here is the Code from merci_dics.xsp (445-470): // nested result set if (_esql_query != null) { _esql_queries.push(_esql_query); } _esql_query = new EsqlQuery((ResultSet) (_esql_query.getCallableStatement().getString(1) <-- 451 ) ); { if (_esql_query.hasResultSet()) { do { _esql_query.getResultRows(); if (_esql_query.nextRow()) { } else { } _esql_query.getResultSet().close(); } while(_esql_query.getMoreResults()); } else { } } The sp_Proc on Oracle_Side is just for testing: Procedure cocoon_proc (intext in out varchar2) IS BEGIN intext:='Erzaehl doch keinen '||intext; END; -- Best regards, Michael mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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]>