How to pass multiple selections from Web page to PL/SQL agent?

Hi all,

I want to pass a multiple selections item back to the PL/SQL agent from the Web page. As the return string will be like this '.../display_city?p1=Chicago&p1=New+York&p1=London', how can PL/SQL procedure capture all values.

The procedure will be like this.

PROCEDURE DISPLAY_CITY (
p1 varchar2(50) ) IS
v_qry varchar2(4096);
v_i number;

BEGIN
  v_qry := 'select city_name from city

            where city_name in :city_name';   v_i := owa_util.bind_variables(v_qry, ':city_name', p1);   ....
END; All I can archive in this example is Chicago, not New York or London. Anyone can point me to the right direction to do this?

TIA, Zeus Ng Received on Mon May 25 1998 - 00:13:52 CDT