Subject In firebird store_procedure IN clause is not giving the desired result
Author mauleen2001
Hello,

I am having one problem in store-procedure. I am passing a variable
value as a input parameter in a store-procedure and that value is used
in following statement (:varValue and its value is 'FL000001','FL000003')

Delete fileid from container where fileid in (:varValue)

I can not get the desired result.

If i use the hard coded value then it works fine. for ex.
Delete fileid from container where fileid in ('FL000001','FL000003')

What could be the problem?