in reply to Oracle report converter

A small sample of the data and example of the expected result may help. Some code showing what you have tried would help even more.

DWIM is Perl's answer to Gödel

Replies are listed 'Best First'.
Re^2: Oracle report converter
by denzil_cactus (Sexton) on Jun 25, 2007 at 06:19 UTC
    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....
[reply]
[d/l]

      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]

In Section Seekers of Perl Wisdom