Support script variables in cursor declaration
Would be nice if you could use script variables in cursor declarations. For example, using a variable as a table name. Currently you must construct the cursor statement using strings and execute it with EXECUTE IMMEDIATE. This works fine except that EXECUTE IMMEDIATE doesn't return any results. Any results from the cursor must be temporarily stored elsewhere for use later.
3
votes
1 comment
-
dfaucette
commented
This would be a very important feature for us. It would enable us to move legacy client-side code to server-side SQL stored procedures.