PLSQL: Passing list of values?

From: <nasof_at_my-dejanews.com>
Date: Thu, 02 Jul 1998 15:10:40 GMT
Message-ID: <6ng7tf$r2b$1@nnrp1.dejanews.com>

Basically, I would like to pass a comma separated list of values into a stored procedure that would use it in an "IN" clause.

ex:
execute update_records('1,2,3,7')

where update_records looks something like:

procedure update_records( var_list varchar(20) ) is BEGIN
update recored_table set rec_detail='updated' where rec_id in (var_list);
END; Is this possible??

-Frank

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 10:10:40 CDT