Re: Synonyms in Stored Procedures
From: Loyal Barber <lbarber_at_ix.netcom.com>
Date: 1996/10/25
Message-ID: <3270E3F1.4A8D_at_ix.netcom.com>#1/1
Date: 1996/10/25
Message-ID: <3270E3F1.4A8D_at_ix.netcom.com>#1/1
DataCeutics, Inc. wrote:
>
> I think I know the answer to this but I'd like some validation. Synonyms
> referecned within a stored procedure are resolved AT COMPILE TIME, not at
> user execution right ?
>
> If this is the case, does anybody have a clue as to how I could dynamically
> build a table name reference in a cursor for loop construct ?
>
> thanks.
>
> pdm
I believe it also evaluates it at runtime. You could use dynamic sql
(dbms_sql package) to create synonyms on the fly. This will work.
Loyal Received on Fri Oct 25 1996 - 00:00:00 CEST