So from your code I'm assuming it is the CREATE that isn't working, not the
drop. I've seen that error message when trying to drop a table and there is a
"declare cursor" still defined on a temp table that was never dropped. There's
only one thing I can think of with the Create, and that's whe
Hi Doug,
What Tony says. The Temp Tables are deleted automatically when the
session is closed anyway and row deletion is not problematic anyway.
On Saturday, May 27, 2023 at 3:09:35 AM UTC-4 Tony IJntema wrote:
> Hi,
>
> Though it is maybe not the expected answer to your question, it could b
Hi,
Though it is maybe not the expected answer to your question, it could be
a solution for your problem.
What you can do is create the temp table once and then only delete all
the rows when you start the procedure.
Tony
Op 27-05-2023 om 05:35 schreef Doug Hamilton:
I create a temporary
3 matches
Mail list logo