| Oracle Reports Error!!!!Please help [message #139597] |
Wed, 28 September 2005 14:53 |
msingla
Messages: 3
Registered: April 2005
|
Junior Member |
|
|
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 5000(or pdf output file size less than 1MB) 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\@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";
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
