ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicholoz Koka Kiknadze <kikna...@gmail.com>
Subject Re: PL/SQL package level variables
Date Tue, 04 Aug 2009 05:59:05 GMT
Hm, but I have used package variables at Oracle 9 times (with JDBC though,
but iBatis just wraps JDBC) and it worked fine.

May I ask how do you handle transactions, and may I look at the code snippet
calling those procedures?

On Tue, Aug 4, 2009 at 9:44 AM, CuriousMind <yogeshcjadhav@hotmail.com>wrote:

>
> Hi Nichol,
>
> Thanks for your response. We are already using same transaction while
> calling these procedures.
> But we are not getting expected results.
>
>
>
>
> Nicholoz Koka Kiknadze wrote:
> >
> > You are quite right. Your problem is that calls to those two procedures
> > are
> > not in a single transaction. Include them in a single transaction and
> > proc2
> > will see package level variables set in proc1. Note that executing those
> > procs on a single connection object is not enough (i.e. you need
> > transaction).
> >
> > hth
> >
> > On Tue, Aug 4, 2009 at 8:48 AM, CuriousMind
> > <yogeshcjadhav@hotmail.com>wrote:
> >
>
> --
> View this message in context:
> http://www.nabble.com/PL-SQL-package-level-variables-tp24802267p24802615.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