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

yorelnewo-lists_at_yahoo.com (Rick Owen) wrote in message news:<ad8adf2d.0310290713.4a960ee2_at_posting.google.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="return 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 <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 - 19:09:46 CET