Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Drop temprary table in stored procedure

    I have a stored procedure in DDF with a temporary table.
    How can i drop a temporary table in a stored procedure with a CURSOR WITH RETURN in the temporary table ?.

  2. #2
    Join Date
    Nov 2005
    i don't think you can, not in the same SP. the cursor should be a pointer on the table, not a real object containing data. you can drop the table only after you move the data from the table to another destination, by the cursor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts