Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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).Received on Fri Dec 12 1997 - 00:00:00 CST