Re: Code Sharing: How can I use one set of stored procedures with two sets of data?

Have you considered putting all the Procs into a package, pinning it to the SGA and then using a remote link?

In article <956656288.764597_at_gamma.star.spb.ru>, Sergey_at_STAR.SPb.ru says...
> Hello
>
> I have a set of stored procedures and packages which are used through OLE
> DB.
> They process data from a set of tables.
> I'd like to fill in the tables in two different ways. I create two users,
> two sets of tables and fill in the tables. Can I configure ORACLE 8.05 to
> support both types of fillings and use only one copy of the code?
>
> Thank your in advance
> Sergey
> <sergey_at_star.spb.ru>
>
>
>
>
 

-- 
Regards,


William.
 
EuroNet*Internet BV, http://www.euronet.nl/
Wm. G. Urquhart, Oracle DBA
Muiderstraat 1, Postbus 11095, 1001 GB Amsterdam
T:+31 20 5355263, F:+31 20 5355400, E: williamu_at_nl.euro.net
M:+31 06 28206038 ICQ: 56047340