Re: Can you pass table/view name to a procedure?

Robert Augustyn wrote:

> 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

 The only way to do it, it to use dynamic sql, take a look at dbmssql.sql in your oracle home/rdbms/admin directory.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net (home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the FREE, drop
column script
ICQ UIN:  2832230(&oracle, home).