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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Executing stored procedures of another schema

Re: Executing stored procedures of another schema

From: <bhogak_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 01:45:15 GMT
Message-ID: <6plurb$psu$1@nnrp1.dejanews.com>


In article <6plo8h$ekn$1_at_nnrp1.dejanews.com>,   bhogak_at_my-dejanews.com wrote:
> There are multiple ways to achieve what you want. I will try to give couple of
> examples.
> 1. You can create a synonym for your table(tableB) as tableA and use the same
> procedure.
> 2. Try to pass the table name to the procedure as an IN parameter.
> 3. Use DECODE statement to get the table you want.
> 4. You can as well use dynamic sql to achieve this.
>
> 1 is the easiest of the lot. As you know, lot depends upon other
functionalities.
>
> In article <35BE07DD.178B_at_eu.pnu.com>,
> piero.stanchi_at_eu.pnu.com wrote:
> > Hi everybody.
> > UserA has tableA and procA. UserB has tableB: tableB has the same
> > structure of tableA but different data. If I execute procA from userB,
> > procA uses tableA. I would like to execute procA in userB on tableB
> > without having to recompile and store procA in userB. Is it possible? It
> > would be useful, because in this way I can centralize the procedures
> > that are the same for all users in just one user.
> > Thanks for any hints.
> >
> > --
> > Piero Stanchi - Engineer
> > Voice: +39 2 48384265 - Email: piero.stanchi_at_eu.pnu.com
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 28 1998 - 20:45:15 CDT

Original text of this message

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