Hello,
I'm using Cocoon 2.02 and need some help with esql. I'm trying to access a resultset
the column of another resultset returned by my query, but I don't get it running. DBMS
is Oracle 9i and the return value of f_searchentries is a refcursor. The
select-statement works correctly in the sql worksheet. And the get-column-type-name
returns refcursor in the outer result element. The row tag isn't closed in the result,
but there are no errors in the error log. Any comments?
========================================================
<esql:execute-query>
<esql:query>
select 1 as dummy , f_search(1,2,56) as result from dual
</esql:query>
<esql:results>
<esql:row-results>
<row>
<esql:get-column-type-name column="2"/>
<esql:results>
<esql:result><xsp:expr><esql:get-array
column="2"/>.getResultSet()</xsp:expr></esql:result>
<esql:row-results>
<innerrow>
<esql:get-columns/>
</innerrow>
</esql:row-results>
</esql:results>
</row>
</esql:row-results>
</esql:results>
</esql:execute-query>
========================================================
Thanks for your help
Malte Vahlenkamp
------------------------------------------------------------------------------
Malte Vahlenkamp
Software Development
Bruker Daltonik GmbH
Fahrenheitstr. 4
28359 Bremen, Germany
Phone: +49-421-2205-486
email: [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]>
