|
|
Archives of the TeradataForum
Message Posted: Wed, 21 Dec 2005 @ 14:04:34 GMT
Subj: | | Re: Passing the value for an IN clause to a stored |
|
From: | | Victor Sokovin |
| I'd like to create a stored procedure that can accept a string with multiple values as a parameter, and then put that into an IN clause in
the query. | |
You might be better off using dynamic SQL in this case. Build your statement into a variable first, and then try EXECUTE IMMEDIATE <your
statement>. Details and examples of dynamic SQL should be available in the manual.
Regards,
Victor
| |