Dynamic Cursor

[Mariano Su]

I need to make a cursor that can be changed depending on the parameters of the procedure....

for example: I have a procedure "CREATE PROCEDURE updateTable(IN variable INT)"

I need the statement for the cursor to include that variable....

declare table_cursor cursor for select field1,field2 from tb_table where field3=variable;


is that possible?

thanks very much