Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Code Sharing: How can I use one set of stored procedures with two sets of data?
Ok, but performance drawbacks will be considerable on these ways.
Sergey
michael_bialik_at_my-deja.com wrote in message <8e6ha8$kj8$1_at_nnrp1.deja.com>...
>Hi.
>
> The answer is "may be" ( depends how much work you prepared to do ).
> 1. Consider moving to 8i ( it has "INVOKER RIGHTS" so it may
> solve the problem ).
> 2. You can completely rewrite your procedures with DBMS_SQL ( by
> using DBMS_SYS_SQL.PARSE_AS_USER instead of DBMS_SQL.PARSE you
> can solve the problem as well ).
> 3. My preferred solution is to use one set of tables and add
> "APPL_ID" field to each table, so different users will use
> different APPL_IDs, but still work with one set of stored
> functions/procedures/packages.
>
> HTH. Michael ( s privetom ).
>
>
>
>In article <956656288.764597_at_gamma.star.spb.ru>,
> "Sergey Yurkevich" <Sergey_at_STAR.SPb.ru> wrote:
>> 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>
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Apr 26 2000 - 00:00:00 CDT
![]() |
![]() |