passing multiple values to input parameters of a view inside a plsql block

[Former Member]

I have a view that can take multiple values for its input parameter. If i query the view from sql command line i can use the following syntax

SELECT * FROM "_SYS_BIC"."my_projects/my_view ('PLACEHOLDER' = ('$$in_parm1$$','value1','value2' ));

But if i have to select from the view inside a plsql block , say a function , then i usually use the syntax

SELECT * FROM "_SYS_BIC"."my_projects/my_view (PLACEHOLDER."$$IN_PARM1$$" => :IP_PARM_VALUE) ; -- where IP_PARM_VALUE holds one value

My question is how can we pass multiple input values inside to the view when view is queried inside a plsql block

Hoping for a quick response

Thanks,

Shrividya

[former_member594385]

Hi Shrividya,

You can use the below syntax to pass multiple values in your function/procedure.

SELECT * FROM "_SYS_BIC"."my_projects/my_view (PLACEHOLDER."$$IN_PARM1$$" => :IP_PARM_VALUE,PLACEHOLDER."$$IN_PARM2$$" => :IP_PARM_VALUE2) ;

where IN_PARM2 is a second input parameter.

Hope this helps.

Thanks,

Jay.