Parsing form fields using pl/sql - not a newbie, but this one has me stumped.

[Rick Owen]

Greetings,

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 <selectwhich 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_lis t 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.

[Rick Owen]

yo************* @yahoo.com (Rick Owen) wrote in message
news:<ad******* *************** ****@posting.go ogle.com>...

Just to clarify. The form is an HTML form (not an oracle form). The
form tag looks like:

<form action="http://server/psl/acc/rpt_eadoc.eadoc _setup"
method="post" onSubmit="retur n verify(this);" name="myform">

Greetings,

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 <selectwhich 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_lis t 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.