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 <yogeshcjad...@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 > > <yogeshcjad...@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-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > >