Re: Can you pass table/view name to a procedure?
From: Sanjay Mathew <alsm1_at_micro.lucent.com>
Date: 1997/12/12
Message-ID: <34918435.F3E_at_micro.lucent.com>#1/1
Date: 1997/12/12
Message-ID: <34918435.F3E_at_micro.lucent.com>#1/1
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 5967Received on Fri Dec 12 1997 - 00:00:00 CET