I have a form that, when submitted, calls a plsql procedure. The form
has a number of fields (text, hidden, select, radio) but the
particular field that is giving me problems is a <select> which allows
multiple selection. When I receive the form values in my procedure I
getting only the first value of those that are selected. For example
if I select 1000, 1100, 1200, 1300 in the list I only get 1000 in my
procedure. If I send the form to a ColdFusion template that dumps the
contents of the form fields I get
org_list_pick="1000,1100,1200,1300"
but when I get the contents of the form fields in the plsql procedure
I only see the 1000.
My procedure is defined as:
PROCEDURE eadoc_setup (searchwhat IN VARCHAR2 DEFAULT 'emp',
report_emp IN VARCHAR2 DEFAULT NULL,
orgqry IN VARCHAR2 DEFAULT NULL,
report_org_id IN VARCHAR2 DEFAULT NULL,
org_code_pick in varchar2 default null,
ckmatrix IN VARCHAR2 DEFAULT 'no',
report_code IN VARCHAR2 DEFAULT NULL,
report_code_list IN VARCHAR2 DEFAULT NULL,
listqry in varchar2 default null,
org_code_list in varchar2 default null,
startdate IN VARCHAR2 DEFAULT '01/01/1950',
orderby IN VARCHAR2 DEFAULT 'org' ,
searchtype IN VARCHAR2 DEFAULT 'simple') IS
org_code_pick is the variable that is causing me the problems.
We are using OAS on an HPUX box. I'm not sure of the version of OAS.
Our database is 8.1.7.
I have tried submitting the form with both get and post with the same
results. This is actually the first time I have tried parsing a
select statement with "MULTIPLE" using pl/sql, however I have been
parsing forms with pl/sql for several years.
What am I doing wrong?
TIA,
Rick.