Re^2: Oracle report converter

Well I havent tried the code yet... The .rpt file contains these sort of lines


.declare myID             99
.declare myNote            9999999
.declare rateCount        9999

.define get_in

        select key, key1, rate_pr,Nt
          into booking_seq, f_no, 
               print_rates, myNote
          from ed_tab
         where ed_tab.tag = 'BKNG'
           and ed_tab.key = 'PRN'
           and ed_tab.user_id = usr
[download]

I just want to know ..how to do this..I mean how to read this type of file which contains declared variables and sql query...If I open the file and read line by line how could I know on which line variable is declared and on which line query is written..because after reading line by line ,I will have generate the report..... Need your guidance only....

Comment on Re^2: Oracle report converter Download Code

Replies are listed 'Best First'.
Re^3: Oracle report converter by GrandFather (Saint) on Jun 25, 2007 at 08:01 UTC
My guess is that that could be a pretty big job. To parse the file you probably want to look at something like Parse::RecDescent then use the output from that to dispatch a series of DB accesses using DBI to retrieve the required report data. Possibly you would then use Template::Toolkit to generate the formated report. DWIM is Perl's answer to Gödel	[reply]