On 18 Dec 2004 at 9:53, wojciech_materna wrote:

>Do You know a method to put table name as parameter to stored
>procedure and retrive columns from it? F.ex I have 5 tables with
>different names TABL1,TABL2.... TABL5, same structure - and I want to
>create one stored procedure which returns rows (after little
>calculation) from one if them - with name passed in anyway to
>procedure. The way not to create 5 stored procedures but only one.

Of course, you can use 'execute statement' or many IFs in the
stored procedure, but if I were you, I'd put all data into one table.
I have no idea why many tables with the same structure and containing
about the same data may exist. May be the developer must learn
something about dababase design?.. I've heard about something called
"normal forms"...
--
SY, Dimitry Sibiryakov.