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

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 )

sybase sybase-asa

Solution 1:^[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?

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	SeanH