Re: changing schema within a stored procedure?

From: Douglas Dunnigan <douglas_at_yogananda-srf.org>
Date: 1997/06/14
Message-ID: <01bc7911$ac2bfc60$93570c26@systems-douglas>#1/1

I think you'll need to use dynamic SQL via the DBMS_SQL package

Doug

RGCheek388 <rgcheek388_at_aol.com> wrote in article <19970614135501.JAA06558_at_ladder02.news.aol.com>...
> I am told there are ways of passinga schema name to a stored procedure
and
> accessing that table. Nobody seems to know exactly how it is done, but I
> hear it has to do with the data dictionary. Anyone know how? Does it use
> the object ID? The system I am working on has parralel schemas with
tables
> that nearly mirror each other, and I would like to have one set of
> functions that manipulate all those schemas witha set ov views to
> standardize the column names. Is it do-able?
Received on Sat Jun 14 1997 - 00:00:00 CDT