>>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.