hi,
some time ago i had the same question and the same problems, here's is my
working solution for calling a ORACLE SP :
<!-- search for businessunit's -->
<esql:execute-query>
<esql:call needs-query="true>">{ call
CONTACTS.searchBusinessUnit(<esql:parameter direction="in"
type="String"><xsp:expr>pattern</xsp:expr></esql:parameter>,<esql:parameter
direction="out" type="CLOB"/>) }</esql:call>
<esql:call-results>
<businessunit-search>
<esql:get-xml column="2" from-call="yes"/>
</businessunit-search>
</esql:call-results>
</esql:execute-query>
annother strange effect , take care the your call statement starts on the
same line like your "esql:call" element.
hth,
Frank
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
