How to pass Multiple input parameters in Calculation script view

[SrinivasReddy]

Hi all,

I am currently facing the issue,

When i am passing input Single  Value  to a input parameter  its working fine

SELECT  "EMPNO", "NAME" FROM "_SYS_BIC"."pkg_one/CALC_VIEW_EMP" ('PLACEHOLDER' = ('$$IP_EMPNO$$', '1'))

When i  pass Multiple Values to a input parameter, Its not working its showing empty values as out put

SELECT  "EMPNO", "NAME" FROM "_SYS_BIC"."pkg_one/CALC_VIEW_EMP" ('PLACEHOLDER' = ('$$IP_EMPNO$$', '''1'',''2'''))

SELECT  "EMPNO", "NAME" FROM "_SYS_BIC"."pkg_one/CALC_VIEW_EMP" ('PLACEHOLDER' = ('$$IP_EMPNO$$', "1","2"))

SELECT  "EMPNO", "NAME" FROM "_SYS_BIC"."pkg_one/CALC_VIEW_EMP" ('PLACEHOLDER' = ('$$IP_EMPNO$$', 1","2))

Did anyone have the same issue and a possible solution?

Thanks a lot

Srinivas

[SergioG_TX · Accepted solution]

Srinivas,

can you change your scripted view into a stored proc? if so, here is a solution on my blog

you will see the solution from calling from an xsjs code, but the same holds true if you just call your stored procedure from within sql console. make sure your input type is a table type and then you can pass it multiple values.

hope this helps!