Aren't GLOBAL TEMPORARY tables viewable to all connections?
I thought so. This is not the case? I want the table scoped to my sp only (i.e. so that it can be fired simultaneously by n-users. Is the trick just to name the temp tables uniquely so that it doesn't matter if they all can see each other)?
Thanks.
bcnu,
Mikem
If you can read this, you are not the President.