Oracle webserver and passing parameters longer than 2000

From: Asad Rustum <asad_at_online.bonnier.se>
Date: 1997/02/19
Message-ID: <330B54A1.6A28@online.bonnier.se>#1/1

I'm having problems with passing parameters to a PL/SQL procedure from a webpage. I'm using webserver 2.0.2 and Oracle 7.3.2. Here's what I'm trying to do:

Assume a webpage with a dynamic number of text areas for input. I do not know in beforehand how many fields I'll have so I've followed the example in the webserver user's guide and am using a PL/SQL table for the passing of the parameters.

My PL/SQL table is defined as follows:

TYPE param_acc IS TABLE OF varchar2(32000) INDEX BY BINARY_INTEGER; The procedure I'm calling is defined as follows:

procedure submit(

    Name in varchar2 default NULL,
    Email in varchar2 default NULL,
    Answers_tbl in BH_pack.param_acc);

The relevant HTML (from a PL/SQL procedure) is:

htp.p('
<FORM METHOD="POST" ACTION="BH_pack.submit">
<INPUT TYPE="TEXT" NAME="Name" SIZE="25" MAXLENGTH="50"
VALUE="'||Name||'">
<INPUT TYPE="TEXT" NAME="Email" SIZE="25" MAXLENGTH="50"
VALUE="'||Email||'">
<INPUT TYPE="HIDDEN" NAME="Answers_tbl" VALUE="foo">
<INPUT TYPE="HIDDEN" NAME="Answers_tbl" VALUE="

    '||Question_rec.id||'">
<TEXTAREA NAME="Answers_tbl" COLS="75" ROWS="4" WRAP="PHYSICAL">

    '||Answer_tbl(counter)||'</TEXTAREA>
</FORM>

');

Anyway, this works fine until the TEXT AREA variabel is > 1999 characters. Passing something longer than 1999 characters shouldn't be a problem. I've done it before but I've never done it through a PL/SQL table.

Looking in the DCD-error-log I find this:

Wed Feb 19 18:10:12 1997
OWS-05101: Agent : execution failed due to Oracle error 2005

  OWA SERVICE: OWA_DEFAULT_SERVICE
  PROCEDURE: BH_pack.submit
  PARAMETERS:

---

  NAME:
   Asad Rustum

  EMAIL:
   asad_at_online.bonnier.se  

  ANSWERS_TBL:
   foo
   1

   foo
   2

   foo
   3

   foo
   4

That is, nothing has been passed from the TEXT AREA fields. Now using 'oerr' I find the following:

asad> oerr ora 2005
02005, 00000, "implicit (-1) length not valid for this bind or define datatype"
// *Cause:
// *Action:

Does any out there know what I'm doing wrong? Any help is appreciated!

---

asad rustum									Bonnier Online
voice: +46 8 663 14 55						Norra Hamnvägen 20
fax  : +46 8 663 58 05						115 42  Stockholm
email: asad_at_online.bonnier.se				SWEDEN

Received on Wed Feb 19 1997 - 00:00:00 CST