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
