Home » Developer & Programmer » Reports & Discoverer » Searching reports (10g)
Searching reports [message #396964] Wed, 08 April 2009 08:59 Go to next message
yog_23
Messages: 79
Registered: March 2007
Member
I have a situation where I have tons of reports , source code is in SVN .

I need to perform a text search on oracle reports to find if any of the queries or reports use a oracle package / function / procedure.

Whats the best way to do this. Are there any tools / program available ?

Assume I have copied it over to a local drive..how to you search on oracle reports..

I thought of a script which reads line by line and find the string..but this works only for other kinds of programs (e.g. c++ code). I am not sure how to text search a oracle report.

Thank you
Yog
Re: Searching reports [message #397066 is a reply to message #396964] Wed, 08 April 2009 14:40 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
source code is in SVN .
What is this?
Same as this link. You can convert them to rex files.

By
Vamsi
Re: Searching reports [message #397110 is a reply to message #397066] Thu, 09 April 2009 01:06 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; but I guess that converting tons of reports into REX files and then search for ... something ... isn't quite an option.

Do I have something smart to suggest? Unfortunately, not.
Re: Searching reports [message #397430 is a reply to message #397110] Fri, 10 April 2009 11:48 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Agreed..
Opening each report and converting to rex may be a tedious job.
But using the following command we can achieve this.
I think for 10g - rwconverter not sure about the syntax
For 6i - rwcon60

By
Vamsi
Previous Topic: problem in Report
Next Topic: How to separate report layout sections in one report
Goto Forum:
  


Current Time: Thu Mar 28 10:54:49 CDT 2024