procedure stored
Hi...
I created the following procedure stored:
create procedure sp_selectin(incoditicu char(30000))
returning integer, char(50) ; define p_coditicu integer ;
define p_nombticu char(50);
foreach
select coditicu, nombticu
into p_coditicu, p_nombticu
from tticu
where coditicu in (incoditicu)
return p_coditicu, p_nombticu with resume ; end foreach;
end procedure;
incoditicu -> is sequence of number that I'll use in 'where coditicu in
(incoditicu)' sentences.
But, the problems is when I call to sp_selectin procedure an string like ...
String coditicu = "2,4,5";
{call sp_coditicu(" + coditicu + ")}
The procedure understand it how different arguments.
What can I do?
Thank you.
sending to informix-list