on 03-08-2016 2:17 PM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.