cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank Taffelt" <frank.taff...@interface-business.de>
Subject Re: Oracle SP with ESQL an c2 2.0.3
Date Tue, 10 Dec 2002 11:34:22 GMT
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message