Re: table name as parameter to a PL/SQL procedure?

Hi, Howard...

I would think you could just declare your procedure with one IN parameter of VARCHAR2 ( table_name_ IN VARCHAR2 )

....and then use dynamic PL/SQL to do your thing with the tables in the procedure... I don't know what you want to do, so I can't give you any good examples... It should be perfectly possibly though.

I hope this was of some help to you...

Regards
$Oyvind

Howard Lee Harkness wrote in message ...
>Is is possible to pass a table name to a PL/SQL stored procedure? I
>have a transform that I want to apply to 33 different tables, and I
>would like to be able to write code that looks like:
>
>Transform('table_1');
>Transform('table_2'); -- etc.
>
>If this is possible, I hope that someone will post a syntax example.
>If it is not possible, I hope that someone will point out another way
>to accomplish my task.
>
>TIA
>hlh_NOSPAM_at_excite.com is a valid, unmunged address!
>It is also so full of spam(!) that I don't read it.
Received on Wed Jul 21 1999 - 18:37:32 CDT