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

Oracle 1.6 ? are you talking about dev2k? What I would like to do is to have a generic procedure which I can call from a trigger.
Would that apply?
Thanks
robert

Sanjay Mathew wrote in message <34918435.F3E_at_micro.lucent.com>...
>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
>
Received on Sat Dec 13 1997 - 00:00:00 CET