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@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 - 12:27:21 CDT