Query in Oracle report [message #186952] |
Thu, 10 August 2006 04:58  |
orafan2003
Messages: 122 Registered: February 2006
|
Senior Member |
|
|
Hi,
I already posted the query in report section..but did not get any answer..if anyone can guide me here...i will be thankful/
I am using a distribution portlet in a portal and trying to enter report details like name of report,its location, parameters involved and when I view these applied changes, I am getting an error.
REP-56055: Exceed max connections allowed: 20" Oracle Reports Error
So to fix this I followed the following steps.
http://www.rittman.net/archives/000514.html
The problem is not fixed and all the different reports that use this distribution portlet are giving the same error. The problem is not with the distribution portlet. It is from the report side. Whe I try to open the report with its URL, it does not give me any error. Only when I put it in the distribution portlet, it gives the above error.
Any solution?
|
|
|
|
Re: Query in Oracle report [message #187139 is a reply to message #187097] |
Fri, 11 August 2006 01:56   |
orafan2003
Messages: 122 Registered: February 2006
|
Senior Member |
|
|
>>Which version of Reports , Application Server, Operating System are you using?
I am using Reports 10.1.2.02
Application server 10.1.2
OS Windows2000 Professional
Another problem is that everytime I open my report in the report builder, it gives me an error
REP-1247 -Report contains uncompiled PLSQL.
So I have to recompile the PLSQL everytime. Eventhough I save these changes, this error is coming up the next time.
Is there a solution for this?
|
|
|
|