Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Code Sharing: How can I use one set of stored procedures with two sets of data?

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

From: Sergey Yurkevich <Sergey_at_STAR.SPb.ru>
Date: 2000/04/26
Message-ID: <956746956.124746@gamma.star.spb.ru>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US