How to pass TEXT(the list of id's as a string) to sybase ase stored procedure

Question

How to pass TEXT(the list of id's as a string as I have long list of id's) to sybase ase stored procedure call?

If I want to pass TEXT to stored procedure call then how can I use same TEXT in where IN query of sybase?

CREATE PROCEDURE Collect_List( @ids_list TEXT )

Answer 1

Looks like this is not an efficient way to pass dynamic IDs in the query. Why don't you use temp table to do it?