Hello, Sergio!

Tuesday, May 22, 2012, 3:25:43 PM, you wrote:

S> Hello! I have a simple SP with something like this:

S> select my_field
S> from some_table
S> where id in (1,3,56,100)

S> How can I do to pass "(1,3,56,100)" a an input parameter?


Simple:

Select something
From Table T
Where :ParamStr Containing '~'||T.ID||'~'

then you set :paramstr to string like this
'~12~23~267~675~'

--
Dmitry Kuzmenko, www.ib-aid.com