ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ellis Miller <outlaw...@gmail.com>
Subject Re: Is there any intention of fixing this 'Ref Cursor' issue: IBatis-350
Date Thu, 17 Sep 2009 04:22:17 GMT
Instead of using ref cursors as OUT parameter of an Oracle stored procedure
just curious if you tested using a Function returning a ref cursor and then
called the Function from another procedure and got the same result.

In this particular case doesn't alleviate the issue with the ref cursors in
the existing PL/SQL code base as Procedures cannot/should not be converted
to Functions for this reason, only, yet for anyone/everyone else still would
be curious: does a Function opening and returning a Ref Cursor generate the
same error if the Function is called from another Procedure.

Regardless, what you are describing: declare ref cursor and reference in
procedure_1 as OUT parameter then procedure_2 calls procedure_1 which
actually opens and returns the ref cursor as an OUT parameter.

Seems very odd as whether calling the procedure from another PL/SQL
procedure or from Java: ref cursor should remain open until it is explicitly
closed by the calling stored procedure/anonymous block/Java. In fact, I have
seen more issues with Java code where the programmer forgot to close the
cursor generating the opposite error.

Wish I could help but my primary experience is PL/SQL and Java but not
familiar with the Ibatis code base, whatsoever. Still, not a good solution,
but would be interesting in knowing whether the use of a Function returning
a ref cursor produces the same error.

On Wed, Sep 16, 2009 at 7:23 PM, happentrack <parvez.sayeed@gmail.com>wrote:

>
> No I meant the choice of using ref cursors all over the place was out of my
> hand.
>
> I will submit a possible fix but I may need guidance since I am bit
> unfamiliar with this code base.
>
> Thanks for your response.
>
>
> Clinton Begin wrote:
> >
> > What do you mean it's out of your hands?  You can fix it as easily as
> > anyone.  Submit the patch by attaching a file to JIRA.
> > Clinton
> >
> > On Wed, Sep 16, 2009 at 3:28 PM, happentrack
> > <parvez.sayeed@gmail.com>wrote:
> >
> >>
> >> https://issues.apache.org/jira/browse/IBATIS-350 was posted almost 3
> yrs
> >> ago.
> >> This is major issue in my current project as Ref Cursor is heavily used
> >> (granted that may not be best approach). Unfortunately it is out of my
> >> hand.
> >>
> >> Any response is appreciated.
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/Is-there-any-intention-of-fixing-this-%27Ref-Cursor%27-issue%3A-IBatis-350-tp25481068p25481068.html
> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Is-there-any-intention-of-fixing-this-%27Ref-Cursor%27-issue%3A-IBatis-350-tp25481068p25482678.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message