Oracle Reports Error
From: <mannysingla_at_gmail.com>
Date: 28 Sep 2005 12:55:17 -0700
Message-ID: <1127937317.132283.223560_at_f14g2000cwb.googlegroups.com>
I was having some trouble with Oracle reports and was wondering if you can shed some light....
$dir_dest = "../pdf/";
$report_name=chris_carl_nco;
$file_path = $dir_dest.$report_name.".pdf";
$connect_info = "ABC/ABC\_at_XYZ";
$ENV{'ORACLE_HOME'}="/thishost/unix/db/dev2k_6.0";
$ENV{'PATH'} =
"$ENV{'ORACLE_HOME'}/bin/:/opt/SUNWSpro/bin:/usr/bin:/usr/openwin /lib:/etc:/usr/local/bin:/usr/sbin/bin:/usr/ucb:/usr/dt/lib:/usr/ccs/bin";
$ENV{'LD_LIBRARY_PATH'} =
"$ENV{'ORACLE_HOME'}/lib:/usr/lib:/usr/openwin/lib:/us r/ccs/lib:/usr/dt/lib";
$system_command = "rwrun60 ".
system "$system_command"; Received on Wed Sep 28 2005 - 21:55:17 CEST
Date: 28 Sep 2005 12:55:17 -0700
Message-ID: <1127937317.132283.223560_at_f14g2000cwb.googlegroups.com>
I was having some trouble with Oracle reports and was wondering if you can shed some light....
I am displaying 70,000 records amounting to a pdf file of size 15 MB on
internal MPL server using Oracle Reports. Now when I run it on unix
server using rwrun60 it crashed and gives the no errors and no output
pdf file. If I reduce the number of records to 500 everything works
fine on UNIX too(gives me the desired pdf report)Can anybody point out
in right direction.
CODE
$dir_dest = "../pdf/";
$report_name=chris_carl_nco;
$file_path = $dir_dest.$report_name.".pdf";
$connect_info = "ABC/ABC\_at_XYZ";
$ENV{'ORACLE_HOME'}="/thishost/unix/db/dev2k_6.0";
$ENV{'PATH'} =
"$ENV{'ORACLE_HOME'}/bin/:/opt/SUNWSpro/bin:/usr/bin:/usr/openwin /lib:/etc:/usr/local/bin:/usr/sbin/bin:/usr/ucb:/usr/dt/lib:/usr/ccs/bin";
$ENV{'LD_LIBRARY_PATH'} =
"$ENV{'ORACLE_HOME'}/lib:/usr/lib:/usr/openwin/lib:/us r/ccs/lib:/usr/dt/lib";
$system_command = "rwrun60 ".
" REPORT=../reports/$report_name".".rdf" . " DESNAME=$file_path". " DESFORMAT=pdf" . " DESTYPE=file" . " PRINTJOB=NO" . " BATCH=YES" . " PARAMFORM=NO" . " USERID=$connect_info";
system "$system_command"; Received on Wed Sep 28 2005 - 21:55:17 CEST