For example: I want to write a stored procedure which accecpt some values as input parameter. The procedure will select some records from database according the input values one by one. In Oracle ,I can define a parameter type as table or array to input many parameter values once to get results. Thus I needn't run a sql repeatly. Is there any same methods in Sybase? Does Sybase support table or array type parameter in stored procedure?
You can pass multiple parameters (@p1, @p2, etc) and use that, or you create a temp table and populate it before calling the stored proc, and use the info in the temp table to perform the request inside the proc.