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