Create Cursor from prepare statement!!!!

SLauren

Hi Friends,
I want to create a cursor which will get filled up from a dynamic query. For example:

Expand|Select|Wrap|Line Numbers

 SET @sqlQuery := CONCAT('SELECT <field1> FROM <table> WHERE <field2> = <some_value>');

PREPARE stmt FROM @sqlQuery;

Where <some_value> will be decided based on some input value to the procedure.

Can i create a cursor from the above PREPARE statement??

Thanks,
Lauren

SLauren

I could be able to do this with the help of "View". I created a view by selecting the required columns from the dynamic query and then created the cursor from the view.

Thanks,
Lauren

Create Cursor from prepare statement!!!!

re: Create Cursor from prepare statement!!!!

/bytes/development

/bytes/it

/bytes/about