Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Parameter Passing via Pl/Sql - 2000 limit
icon13.gif  Parameter Passing via Pl/Sql - 2000 limit [message #116363] Tue, 19 April 2005 11:47 Go to next message
Messages: 1
Registered: April 2005
Location: Rockville, MD
Junior Member
We have just installed Oracle 10G and run into a new imposed limit of 2000 passed parameters when using PL/SQL. This limit did not exist in 9i. My question is how to override this new limit or extend it. I understand that the parameter that should be extended is called PlsqlMaxParameters and it is or should be located in the plsql.conf file. We have tried several times to add it in with no success. Any ideas.


Tim McIntosh
Re: Parameter Passing via Pl/Sql - 2000 limit [message #116470 is a reply to message #116363] Wed, 20 April 2005 04:56 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

I cannot find any reference to the "PlsqlMaxParameters" parameter in the current documentation (Chapter 7 of the Oracle10g HTTP Server Administrator's Guide).

The only hit on Metalink is Note 280011.1 (Mod_plsql Http-400 Too Many Arguments). However, this covers a similar problem with 9i, not 10g!

Maybe you should log a TAR with Oracle Support and ask them for a fix or workaround.

Best regards.

Re: Parameter Passing via Pl/Sql - 2000 limit [message #116806 is a reply to message #116470] Fri, 22 April 2005 06:08 Go to previous message
Messages: 7065
Registered: December 2001
Senior Member
Have you restarted the HTTP server?

Previous Topic: Problem webutil
Next Topic: Future of Application server
Goto Forum:

Current Time: Wed Feb 28 08:51:12 CST 2024