Use CURSOR results in a Select?

[matthewdhe]

Is this possible?

Select several records into a cursor.

Use the values in the cursor to delete from tables.

I do not want to loop through each cursor value and issue a seperate delete command...

almost something like (psuedo code below)



DELETE FROM table WHERE update_date = c_delete dates;

[svk]

Why cannt you use a subquery ?

DELETE FROM table WHERE date_column in (your_cursor_definition_that_selects_only_the_required_dates);

Or, you may even be able to use 'EXISTS'.