| Subject | Passing a comma separate string to a Procedure |
|---|---|
| Author | firebirddev firebirddev |
| Post date | 2013-11-10T22:34:01Z |
Hello.
I was wondering what is the right way to pass a comma separate string to a Procedure?
EXECUTE PROCEDURE UPD_CUSTOMER_VISITED('val1, val2')
In the procedure I am using the IN operation, like:
SET TERM ^ ;
CREATE PROCEDURE UPD_CUSTOMER_VISITED(
I_NAME_LIST Varchar(4000))
AS
BEGIN
UPDATE CUSTOMER
SET VISITED_FLAG = 'Y'
WHERE NAME_LIST in (:I_NAME_LIST);
END^
SET TERM ; ^
Thanks.