|
I hope this saves somebody some time. Did you
know, that when you create a temporary table, if you create a cursor for that
table, you have to drop the cursor before you can drop the table. If you
try to drop the table without dropping the cursor, you get a somewhat misleading
error messags...something about "Resources are not available".
This may be obvious, but it can be a real problem
that's hard to find. If your app creates a cursor, and then for some
reason (like the app has a bug and you never get to the part where you drop
the cursor) you try to drop the table and recreate it, expecting it to have
no rows of data, it won't drop, the recreate will be ignored, and you will still
have old data in the table where you thought you had no data!
Hope this helps somebody!
Mike
|
