Hi,

I need to call a WF Stored procedure with say 2 parameters. The first parameter can have single numeric value. The second can have Multiple string values.

So the second parameter is like
'val1', 'val2', 'val3'

But at the time of calling the stored proc these 3 values will be considered as parameter2 , parameter3 and parameter4 as they are comma separated and are in single quotes.

How to tell WebFOCUS to read it as a single string??

EX PROCNAME 1000, 'val1', 'val2', 'val3'

Are there any special characters available to tell WF to ignore these quotes and commas?

Thanks,
CD

Try this,

EX PROCNAME 1000, '~VAL1=''&val1''~VAL2=''&val2''~VAL3=''&val3'''

Will this work for calling an Oracle Stored Procedure??

Not sure, you can try it and let us know.

Note: The above syntax is for SQL Server.