Re: REF CURSOR returned from Java -- Solved!
From: Jim Garrison <jhg_at_athensgroup.com>
Date: Tue, 21 Sep 2004 12:27:21 -0500
Message-ID: <K8qdnS79Wd7H-c3cRVn-jQ_at_giganews.com>
Date: Tue, 21 Sep 2004 12:27:21 -0500
Message-ID: <K8qdnS79Wd7H-c3cRVn-jQ_at_giganews.com>
Jim Garrison wrote:
> Oracle has a tech article describing how a Java stored procedure
> can return a REF CURSOR:
>
> declare
> TYPE RC IS REF CURSOR RETURN TEST_INT_TRANS%rowtype;
Make the cursor type generic, thus:
TYPE RC IS REF CURSOR;
and the problem goes away
I guess the cursor loses its class identity when being marshalled through the interface and becomes a generic REF CURSOR, and gets cast back to the correct type automagically on the fetch. Received on Tue Sep 21 2004 - 19:27:21 CEST