From: Sanjay Mathew Subject: Re: Can you pass table/view name to a procedure? Date: 1997/12/12 Message-ID: <34918435.F3E@micro.lucent.com>#1/1 References: <66rutj$g25$1@mail.pl.unisys.com> Reply-To: alsm1@micro.lucent.com To: Robert Augustyn Organization: Lucent Technologies Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools 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 Yes you can starting Oracle Version 1.6. Use dynamic sqls.Its documents in the application developers guide. Hope this helps. -- Sanjay T. Mathew Oracle DBA Lucent Technologies, 555 Union BLVD, Allentown PA 18103 Phone Number Office 610 712 5967