Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multi value prompt Issue

Status
Not open for further replies.

CrystalProgDev

Programmer
Oct 1, 2010
69
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top