| Calling Oracle reports [message #131241] |
Thu, 04 August 2005 22:57  |
m_ashtiani
Messages: 27
Registered: August 2005
Location: Reno
|
Junior Member |
|
|
Hi,
I am new to 10g developer,
Migrating from 6i to 10g.
installed developer suite 10g and configured oc4j for the developer.
got the forms running under browser however reports are problem.
Problem 1:
i used an existing 6i report and re-compiled it. (no migration program under reports). I noticed that it has very little code under web-view, when i run it, report blanks out and sort of hange for a while. at the end it does not run.
created a new report from scratch and managed to run it from reports-developer. it gave me a paperview
Problem2:
Calling a report from form failes. i used report object set to cache, runtime/batch and html output. basically run_report_object returns null after hanging for a while. I called both the RDF and jsp report files. note that i tested report serverlet and it works fine (http:// .../reports/...)
Registery is report_path is setup to my working directory and did not configure anything else for report
i may have miss spelled keywords here as i am not actually looking at the parameters. anyhow I am stuck, help is appreciated
|
|
|
|
|
|
| Re: Calling Oracle reports [message #131270 is a reply to message #131241] |
Fri, 05 August 2005 01:25  |
m_ashtiani
Messages: 27
Registered: August 2005
Location: Reno
|
Junior Member |
|
|
Thank you for your help it is now running with your code,
however i would add these
i've installed oc4j on the same computer as developer. my computer name is mars. to get the name of the server i type
http://mars:8889/reports/rwservlet/getserverinfo
in my case it is called rep_mars, not the usuall repser. note that somewhere in your code repser is hardcoded. i also removed encode function (not have it!).
so this part works,
should a 6i report just covert automatically to 10g or there is a step i am missing
thanks alot
|
|
|
|
|
|
|
|
| Re: Calling Oracle reports [message #131382 is a reply to message #131322] |
Fri, 05 August 2005 13:13 |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
| Maaher wrote on Fri, 05 August 2005 07:19 |
| djmartin wrote on Fri, 05 August 2005 08:32 |
To convert a 6i report to 10g, open the 'rep' file in the Report Builder and then Save it.
|
I don't have 10g around but I think you need the RDF, save it and compile it. My reports builder refuses to open
"Run-only" REP files (REP-0607).
MHE
|
Or rather, open, compile, save as. I have noticed that if you move reports around, sometimes you get the error Report contains uncompiled PL/SQL. This is directly correlated to the location of the .REP file, as per my understanding.
|
|
|
|
| Re: Calling Oracle reports [message #131495 is a reply to message #131382] |
Sun, 07 August 2005 18:42 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
| Quote: |
To convert a 6i report to 10g, open the 'rep' file in the Report Builder and then Save it. I don't recommend using the 'rdf' version of reports.
David
|
My sincere apologies this is the wrong way around ... I must have been having a mega-senior moment.
"Open the 'rdf' file in the Report Builder, compile it to convert the PL/SQL, and then Save it. I don't recommend using the 'rep' version of reports."
Again, my apologies.
David
[Updated on: Sun, 07 August 2005 18:42] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
