Passing strings to cursors [message #37743] |
Tue, 26 February 2002 05:29 |
Brian Kelly
Messages: 4 Registered: February 2002
|
Junior Member |
|
|
Hi All,
Lets take the following example:
where project_id = v_where_clause;
v_where_clause holds ('1111'), the cursor works fine.
now look at this:
where project_id in (v_where_clause);
this time v_where_clause holds ('1111','2222')the cursor fails with no data found.
Can someone please tell me if there is a way of getting a string of values in all at once rather than using a loop to put them in one by one as this is taking to long
thanks
Brian
|
|
|
|