Subject Best Way to Pass a Comma Delimited List of Numbers?
Author Steve Miller
We are porting a fair number of stored procedures from SQL Server to
Firebird. A fair number of these procedures take an input parameter, a
comma delimited list of integers with a type of NTEXT. (Why the system
does that would take some explanation, but in short, they are a list
of object IDs. We have object data mapped to the relational database.)

I am looking how to pass such a comma delimited list of IDs to a
Firebird procedure. The VARCHAR(n) data type is really too small for
the comma delimited list. Is a blob the way to go? If so, what might
the code look like? Blobs have a somewhat daunting amount of
documentation for a newcomer.