OAS 4.0 and Oracle 8i refuse to execute stored procedures with more than 20 input parameters

[Quoted] I'm programming a web application with stored plsql procedures and Oracle Application Server.

I started using Oracle 8.0.5 and OAS 4.0. It was working fine until I needed to use dynamic plsql and decided to upgrade to Oracle 8i (8.1.5).

Some of my stored procedures have more than 20 input parameters and didn't supose any problem in the "old" instalation, but now when I try to execute them via OAS over Oracle 8i it returns an error as if the number of parameters I gave were incorrect.

Modifying the procedure so it has less than 20 parameters works fine.

In resume: with the same input form and the same stored procedure with more than 20 input parameters works under Oracle 8.0.5 but fails under 8i.

Any ideas why the newest version doesn't accept more than 20 parameters?

Thank you.

Miquel Salvà
msalva_at_3digits.es Received on Wed Mar 05 2003 - 17:03:56 CET