Re: 1 Stored Procedure for all Tablespaces

If you want to maintain the emp table in different schemes then you should create the package for the other schemes as well.

Generally you don't want to do this. Most of the time you'll have 1 emp table and many schemes (users) that connect to it. You can create 1 package say in scheme user1 called my_package. Now you are right in saying that user1.my_package uses user1.emp. When you create a public synonym (create public synonym my_package for user1.emp) for the package you can change the data in user1.emp from a different scheme through the package without actually having the access permissions to user1.emp.

Hope this helps,

Gerrit-Jan Linker
Developer of Oraxcel, OraCodes, OraWeb and OraSQL http://members.aol.com/gjlinker

In article <36A450CF.3960C2E8_at_informore.com>,   Barry Ludwig <barry.ludwig_at_informore.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 13:45:39 CST