ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: PL/SQL package level variables
Date Tue, 04 Aug 2009 11:29:06 GMT
You can use an anonymous pl/sql block in ibatis, too.

Larry


On Mon, Aug 3, 2009 at 11:59 PM, Nicholoz Koka
Kiknadze<kiknadze@gmail.com> wrote:
> 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
>>
>
>

---------------------------------------------------------------------
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