Lori,

Create a cursor instead, theay are always unique in a multiuser env and you can name them with meaningful names. They also automatically go away when you close them.

Check out CREATE CURSOR, the syntax is just about teh saem as CREATE TABLE.