OraFAQ Forum: Weblogic & Application Server » Parameter Passing via Pl/Sql

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Parameter Passing via Pl/Sql - 2000 limit

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Parameter Passing via Pl/Sql - 2000 limit [message #116363]

Tue, 19 April 2005 11:47

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

Report message to a moderator

Re: Parameter Passing via Pl/Sql - 2000 limit [message #116470 is a reply to message #116363]

Wed, 20 April 2005 04:56

Frank Naude
Messages: 4581
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

Report message to a moderator

Re: Parameter Passing via Pl/Sql - 2000 limit [message #116806 is a reply to message #116470]

Fri, 22 April 2005 06:08

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Have you restarted the HTTP server?

MHE

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 23:55:00 CST 2024