maximum amount of parameters??

Hellou,

was just wondering is there a maximum amount of parameters which you can transport from one procedure to another. They're all textbox parameters(10 in one row) and are declared in the next procedure declaration, so all of them you'll find in the URL.

I counted 297 as the maximum, after that IE doesn't work, that is, it doesn't switch to the next procedure anymore.

Any thoughts??

IT sounds like you are coding php, but I cannot tell.

php uses the OCI interface, straight C. In which case it is implementation dependent.
See limits.h for the system running the code, look for:


It is usually limited by the number of bytes, not the number of arguments.
I don't know what ARG_MAX is for Windows. For MSDOS it was 4096.

Nope, I'm coding PL/SQL. The thing is as follows: On my startingpage my form gets an unknown amount of rows with 13 fields each from a database and these rows are situated in 3 different tables. Not every field contains data. After that the user can edit these rows, another form is opened. Ten of the fields change into textboxes into which the user can enter data. Now, after pressing a submit button (again a new form is opened) all the rows should get updated, so I'm not using any checkboxes. So every row has 11 parameters during updating, 1 rowID and 10 for the textboxes. The problem is that all these parameters are displayed in the URL of the next form/page, so after pressing the update button. If there are 30 rows that makes 330 parameters. IE works well up to 27 rows, after that nothing happens on pressing the button. Netscape, Opera and Mozilla do work fine.
Does this give ypu a better picture?

i think if understand correctly your problem might not be with oracle or IE...What type of method are you using in the <form> tag of html. if you are using GET...try using POST instead. HTTP Get only allows for certain amout of data.. if there is a lot of data on the form use POST.

let me know how it goes.

Thanks for reacting on my question. It's here about 8 o'clock in the morning so I'm just reading your reply.
Well, I tried the post method (same hint from other people too), but it didn't work yesterday. I tried again today and YES!! it works.
Strange things are happening here , but who cares, it works.
Bey!