avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers

Skip to Content