ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: How to execute a SQLstatement and followed by a StoredProcedure.
Date Wed, 27 Aug 2008 18:21:09 GMT
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 <balar4u@gmail.com> 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?
>

Mime
View raw message