Re: Oracle WebServer: Multivalued Parameters

> I have an HTML form that asks something like "What products do you want
> to search for?" The user can type in something like "product1 product2
> product3 etc..." and then press the Submit button.
>
> After submitting, I need the PL/SQL program to generate code that is
> something like this:
>
> select * from table
> where product like '%product1%'
> or product like '%product2%'
> or product like '%product3%'
> etc...
>

  When you pass the string into the stored procedure for Web, you should tokenize the string into product1, product2 ... in the stored procedure.

  Then, you construct the query by using string concatenation.

  Afterward, you can use dynamic SQL to achieve your purpose.

  Related Topics: DBMS_SQL, Oracle Web, Stored Procedure

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841