Hi, Thanks for your quick reply......that is what thought putting Insert statement in a stored procedure and call external stored procedure from there..... But just wanted to know in Ibatis is there a way to execute both in a single map..
Thanks Bala. On Wed, Aug 27, 2008 at 2:21 PM, Larry Meadors <[EMAIL PROTECTED]>wrote: > Why not just put the insert/sp call in a single stored procedure? > > If not that, I think you'll need to just call the 2 mapped statements, > or find a way to do it with sql (like an anon pl/sql block in oracle). > > Larry > > > On Wed, Aug 27, 2008 at 12:17 PM, bala r <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I need to execute Select statement and followed by a Stored Procedure. > > Stored Procedure parameter is from the SQL Selectstatement result. > > > > 1. Select x into p_x from temp_table > > 2. call stored_procedure(p_x) > > > > Both should be same sqlMap id . > > > > I tried using <statement> but didnt work. > > > > Is there a way shall i execute both in one sqlMap id? > > >
