Re: PL/SQL and multiple checkbox select question

Create the where clause based on the checked boxes and pass the where clause as the varchar2 argument to the procedure.

Andrew Grover (agrover_at_bdsinc.com) wrote:
: I'm using Oracle Webserver 2.1 and Oracle 7.3. I am using PL/SQL to
: generate multiple checkboxes, one for each row in a skill table. I'm
: then using dynamic SQL to search for employees who posses all those
: skills. the dynamic SQL's hairy enough, but I can't pass more than one
: checked item to the procedure! How does one do this?
 

: thanks in advance,
 

: Regards -- Andy

: --
: --------------------------------
: Andrew Grover
: Business Data Services
: agrover_at_bdsinc.com
: (800)677-3693 ext. 3023

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.