Re: Error in more than 20 parameter in pl/sql procedure

From: <leirace_at_my-deja.com>
Date: Sat, 26 Jun 1999 06:21:40 GMT
Message-ID: <7l1rhf$pd4$1@nnrp1.deja.com>

I test this code in OAS 4.07,
if I use
"http://myserver/owa_dba/owa/test?p1=1&p2=1&p3=1&p4=1&p5=1&p6=1&p7=1&p8=
1&p9=1&p10=1&p11=1&p12=1&p13=1&p14=1&p15=1&p16=1&p17=1&p18=1&p19=1&p20=1
"

It's correct; it's will error if there have 21 parameter, like this

"http://myserver/owa_dba/owa/test?p1=1&p2=1&p3=1&p4=1&p5=1&p6=1&p7=1&p8=
1&p9=1&p10=1&p11=1&p12=1&p13=1&p14=1&p15=1&p16=1&p17=1&p18=1&p19=1&p20=1 &p21=1"

But in OWS 2.1, all of above is correct. Is this a limited in OAS 4.X?

Procedure myweb.TEST

   (

   p1 IN varchar2,
   p2 IN varchar2,
   p3 IN varchar2,
   p4 IN varchar2,
   p5 IN varchar2,
   p6 IN varchar2,
   p7 IN varchar2,
   p8 IN varchar2,
   p9 IN varchar2,
   p10 IN varchar2,
   p11 IN varchar2,
   p12 IN varchar2,
   p13 IN varchar2,
   p14 IN varchar2,
   p15 IN varchar2,
   p16 IN varchar2,
   p17 IN varchar2,

   p18 IN varchar2,
   p19 IN varchar2,

   p20 IN varchar2 default null,
  p21 IN varchar2  default null,
   p22 IN varchar2 default null,

   p23 IN varchar2 default null
)

   IS
BEGIN

	htp.p(p1);
	htp.p(p2);
           ....
           ....
	htp.p(p23);

END; -- Procedure

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 26 1999 - 01:21:40 CDT