Re: Executing stored procedures of another schema

Hi!
Hope this helps....

1. Pass tablename as an IN parameter to the procedure and go on from there.
2. Use DECODE statement to pick out the table you want.
3. Can use Dynamic Sql.

1 and 2 needs slight modifications to your procedure code and three is to write from the scratch. Hope this helps...

Note: If procA already exists and it exclusively refers to tableA and if you don't want to change the code, I don't thing it is possible to refer table B.

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 Received on Tue Jul 28 1998 - 19:05:01 CDT