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
mcintosh
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.

Thanks

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: 4579
Registered: April 1998
Senior Member
Hi,

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.

Frank
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
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Have you restarted the HTTP server?

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


Current Time: Thu Mar 28 14:20:04 CDT 2024