So I think that is the query that I am looking for, I am attempting to put the query into a cursor (where I can pass the folder_id) but am not having much success:
When I run in a PL/SQL package, I surprisingly get:
-> Enter value for delete:
Edited by: user12200443 on Nov 21, 2012 12:26 PM
As I don't see any delete (most probably preceded by &) I have to assume that you did not post exactly what you are trying to run.
Also the code you posted is not valid.
Please post all the code you are trying to execute.