> Is this possible to create stored proc with dynamic parameter as an input? > > For example, I have a table like this : > > id value > == ===== > 1 'A' > 2 'B' > 3 'C' > 4 'D' > 5 'E' > > How to create stored proc to returns values from above table but with dynamic > id > as an input? > > For ex, how to return values, if with id in (1,2) or id in (1,2,5), etc. > > In select statement, it will equal to statement like this : > select value from table where id in (1,2) or > select value from table where id in (1,2,5)
I see two ways here: 1) As a VARCHAR input parameter in combination with using [FOR] EXECUTE STATEMENT 'SELECT ... WHERE ' || string || '... INTO ...' 2) By using a global temporary table (GTT): Insert the requested IDs into a GTT outside the SP and then JOIN the base table with the GTT in the SP. -- With regards, Thomas Steinmaurer http://www.upscene.com/
