CrystalProgDev
Programmer
I created a derived table calling a pipelined funtion and trying to pass multi value prompt value as parameter to the funtion. But it is not letting me to do it... throwing an error 'Right Paranthesis Missing'.
param is a single value prompt. param1 and param2 are set to allow multi vlaues.
If I make param1 and param2 as single value (unchecking allow multi value), working fine.
SELECT * FROM (TABLE (Schema.Package.Fun_nm(@Prompt(param), @Prompt(param1),@Prompt(param2))))
when I ran function in Toad by passing values working as expected.
SELECT * FROM (TABLE (Schema.Package.Fun_nm('AAA', 'A,B,C','X,Y')));
Can any one please let me know how to pass multi value prompt as a parameter to piplelined function? iT'S VERY URGENT
param is a single value prompt. param1 and param2 are set to allow multi vlaues.
If I make param1 and param2 as single value (unchecking allow multi value), working fine.
SELECT * FROM (TABLE (Schema.Package.Fun_nm(@Prompt(param), @Prompt(param1),@Prompt(param2))))
when I ran function in Toad by passing values working as expected.
SELECT * FROM (TABLE (Schema.Package.Fun_nm('AAA', 'A,B,C','X,Y')));
Can any one please let me know how to pass multi value prompt as a parameter to piplelined function? iT'S VERY URGENT