How to execute a SQLstatement and followed by a StoredProcedure.

[bala r]

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?

Thanks
Bala.