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]>
