$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: true, vro: true, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content

How to pass Multiple input parameters in Calculation script view

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

111.JPG (43.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 08, 2016 at 06:36 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded