Home » Developer & Programmer » Reports & Discoverer » Maximum Length Of url in report 10g
icon4.gif  Maximum Length Of url in report 10g [message #222703] Tue, 06 March 2007 01:12 Go to next message
SpeakurMind
Messages: 14
Registered: June 2006
Junior Member
Hi,

Can someone let me know as to what the maximum length of the URL string that could be formed? I believe in IE browser a maximum of 64,000 characters can only be formed. If I need to pass many parameters and the length of the values passed exceeds the default length in IE, the rest of the values will not be captured in the report server.

Below is the URL string which i run from IE browser:
http://<my system IP> :7778/reports/rwservlet?report=D:/oracle/Ora91/reports/cs/sample.jsp&P_END_DATE=11/03/2007&P_EMPID=181&destype=cache& desformat=pdf&userid=apps/apps@test.oracle.com
Here only 2 parameters P_END_DATE and P_EMPID is passed.I need to pass many parameters and the length of the parameters is also huge.

Please let me know on how to proceed with this problem.
Re: Maximum Length Of url in report 10g [message #222721 is a reply to message #222703] Tue, 06 March 2007 03:08 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If parameter list is huge, perhaps you should consider another strategy; for example, put parameters' values into a table and let report select and use them.
Re: Maximum Length Of url in report 10g [message #222789 is a reply to message #222721] Tue, 06 March 2007 06:40 Go to previous message
SpeakurMind
Messages: 14
Registered: June 2006
Junior Member
Thanks a lot. I shall try this stratergy and let u know if there are any issues faced.
Previous Topic: submit-query & reset button are not comming!
Next Topic: Cumulative summary in Report
Goto Forum:
  


Current Time: Tue Nov 26 16:38:35 CST 2024