Feedback:

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
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Peter FunkPeter Funk shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Submitting...
      • dfaucettedfaucette commented  ·   ·  Flag as inappropriate

        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.

      Knowledge Base and Helpdesk