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

From: Rick Owen <yorelnewo-lists_at_yahoo.com>
Date: 29 Oct 2003 07:13:42 -0800
Message-ID: <ad8adf2d.0310290713.4a960ee2_at_posting.google.com>


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 <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.
Received on Wed Oct 29 2003 - 16:13:42 CET

Original text of this message