1 Stored Procedure for all Tablespaces

Hi all,

I have been writing some stored procedures. Oracle puts the UserId before the table name.

Is there a way to create a procedure, that will run in the active tablespace for the active user.

Eg

user1.emp using program to average the salary, but if user2 runs this program he gets the result of user1.emp, as user1 has created the program.

How can I work arround this problem

--
Barry Ludwig

Informore BV - Phone : + 31 (0)35 6836560 - Fax : +31 (0)35 6834976 Received on Tue Jan 19 1999 - 03:30:52 CST