>>>I have grave suspicion that there is no workaround here, this is why I never use type 4, and use 1-cursor's alias.
>>

>>I like type 4 for lookups since since you can create a cursor and don't have to bother with creating a temporary table name and then deleting the table. But when all is said and done I recon it's six of one and half a dozen of the other :)

>Also, temporary table (cursor) is not needed to be deleted.

For sure...that's why I said "you can you can create a cursor and don't have to bother with creating a temporary table name and then deleting the table." :)