Re: Synonyms in Stored Procedures
From: Mark Madsen <mark.madsen_at_tswi.com>
Date: 1996/10/27
Message-ID: <01bbc441$9a8757a0$1f9afd80_at_solaak79.dial.pipex.com>#1/1
Date: 1996/10/27
Message-ID: <01bbc441$9a8757a0$1f9afd80_at_solaak79.dial.pipex.com>#1/1
> Synonyms referecned within a stored procedure are resolved AT COMPILE
TIME, not at
> user execution right ?
Actually, synonyms are resolved at both compile and execution time. That is why you can change a synonym without recompiling the procedure and or package.
> 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 ?
Use dbms_sql - see the server documentation addendum for instructions.
Mark Madsen
mark.madsen_at_tswi.com
Received on Sun Oct 27 1996 - 00:00:00 CEST