On 30.May.2002 -- 10:45 AM, Malte Vahlenkamp wrote:
> 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>
Malte, could you be a bit more specific on "don't get it running"?
It would be great if you could try 2.1-dev from CVS since 2.0.2 esql swallows
some exceptions.
Is it correct to use getArray() on a refcursor?
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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]>
