You can use an anonymous pl/sql block in ibatis, too. Larry
On Mon, Aug 3, 2009 at 11:59 PM, Nicholoz Koka Kiknadze<kikna...@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 <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 >> > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org