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

Feb 17, 2017 at 05:59 AM


avatar image
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



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content