list of parameters in stored procedures

[dscnn]

I am trying to pass a list of string parameters in a stored procedure, which will be used in IN clause inside my SP SQL. It used to work in v7 but isn't in v8.

Example, CALL schema.testsp('#pINSQLList#');

while running, I am giving value of parameter as ''1'',''2''. Its failing with error

} is not a valid property list: Expected "," or "}", got: "'1'"

Any ideas how I can pass the values in this variable?
fyi, the SP works when executed from DB2 Toad: CALL schema.testsp('''1'',''2''')

Thanks in advance

[chulett]

Have you tried escaping the inner quotes?

[dscnn]

Yes! Apparantly a single quote Is the escape character, otherwise I have tried /\ spaces, you name it.

[kollurianu]

Try with the double quotes..

CALL schema.testsp("#pINSQLList#");

[dscnn]

Doesn't work.

Like I said, I have tried with single, double triple quotes, /,\,space. It seems it is a bug in v8.1

[chulett]

Then your next stop should be your official support provider.