Re: htp - passing parameter limit?

In article <8jnjr1$qfq$1_at_nnrp1.deja.com>,   miki_at_llnl.gov wrote:
> I am adding a new parameter to an working web form
> generated using the pl/sql web toolkit.
> Pressing the submit button generates a 'Request failed'
> message. If I remove one of the existing parameters
> on the form and leave in the new parameter it works
> fine.
>
> I recall reading somewhere that there is a limit
> to the parameters that can be transmitted via
> the htp package. What are some details about this
> limit and how do I get around it (without having
> to redesign my whole page just for one parameter)?
>
> Thanks,
> Miki Moore
> miki_at_llnl.gov
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

there is no pratical limit o nthe number of input item in a form to be passed to a plsql routine.

If it is just one parameter that is causing the problem -- most likely this error is due to:

• the NAME= in the form has a name that is NOT the name of the parameter (eg: you have a typo).
• you are using method=GET and the environment variable QUERY_STRING is getting too long (use method post).

I'll bet its the first one though. You can set the error reporting level HIGHER and the error message will be more informative then "an error occurred".

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.