CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Advanced: Perl report format and references to hash is creating header issues in 11g(perl version 5.10.0) but fine in 10g(perl version 5.8.4): Edit Log



rath_igit
Novice

May 27, 2015, 4:05 AM


Views: 34571
Perl report format and references to hash is creating header issues in 11g(perl version 5.10.0) but fine in 10g(perl version 5.8.4)

There are some perl report header issues coming after 11g migration in Unix sun solaris(5.10) .we have the perl(5.10.0) in build in 11g under path /data/oraclt/product/clt11.2.0.4.0/perl/bin/perl and we are also using the perl modules under it which is provided by default in 11g.

But this issue is not coming in 10g where we have perl(5.8.4) under /usr/perl5/5.8.4/bin/perl and modules under my home dir.

Now coming to the issue we have some perl reports which is geting created by using commnd line as:
/usr/perl5/5.8.4/bin/perl perlfilename1.pl -dbid=x -dbpw=x -dsn=x -entity=x -date=x -o=perlfilename_report -rptid=x -c
or,(in 11g as below)
/data/oraclt/product/clt11.2.0.4.0/perl/bin/perl perlfilename1.pl -dbid=x -dbpw=x -dsn=x -entity=x -date=x -o=perlfilename_report -rptid=x -c


we are getting all this(dbid,dbpw,dsn etc) from a control file .
This perlfilename1.pl is using some common files where the perl format is defined and some common function is defined to be used by all the .pl whichever is creating reports.I have verified everything in debugger and the observation as follows.

perl format for all report header as below:

Code
format  PAGEHEADER_STANDARD= 
@<<<<<<<<<<<<<< @|||||||||||||||| Date: @<<<<<< @<<<<<<
$$tblreprndata{'entdes'}{'data_value'}, $$tblrep{$$c{repid()}}{'repname'}, $$c{pdate()}}, $$c{pdate()}}


This format being used in function as below and used in all the reports.

Code
WritePageHeader{ 
($c,$cntpag)=$_;
$tblrep=$$c{tabl_rpt()}->data();
$tblreprndata=$$c{tabl_rpt_run_dat()}->data();

select ($$c{outputflhndl()};
$~="PAGEHEADER_STANDARD";
write($$c{outputflhndl()};

}

This function is called in all .pl file to create report page header.
When I see in the debuger the values in hashes $tblrep ,$tblreprndata is not coming in 11g after the select line and 10g I am able to the hash values.So the 10g header is fine and the 11g header is not populating

Whether anyone had faced this kind issues when migrating to 11g?
Please suggest regarding this issue.
Thanks in advance.


(This post was edited by FishMonger on May 27, 2015, 6:39 AM)


Edit Log:
Post edited by FishMonger (Veteran) on May 27, 2015, 6:39 AM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives