Re: Can you pass table/view name to a procedure?
From: JITENDRAN <JITENDRAN_at_prodigy.net>
Date: 1997/12/21
Message-ID: <01bd0dbd$b7501220$07d8edcc_at_jiten>#1/1
Date: 1997/12/21
Message-ID: <01bd0dbd$b7501220$07d8edcc_at_jiten>#1/1
Robert ,
You can pass table name or any object name to a stored procedure and use that variable name in place of table name in SQL statement in procedure.But you have to use dynamic SQL to create the SQL statement at run time.Just try to read about package DBMS_SQL to write the procedure.
Hope you got some idea toproceed.
Robert Augustyn <augustyn_at_unn.unisys.com> wrote in article
<66rutj$g25$1_at_mail.pl.unisys.com>...
> Hi,
> I would like to pass table name to the stored procedure and use it in one
of
> the sqls inside the procedure but had not much lack doing it, is it
> possible?
> Any solutions will be greatly appreciated.
> Robert
>
>
>
Received on Sun Dec 21 1997 - 00:00:00 CET