I have an observation that your user credentials for SQL will be displayed if anyone lists your process. Could you consider butting the credentials in the 'here' document, e.g.:-

Code:

XML_PATH_FLAG=`sqlplus -s <<-EOSQL
$APPS_USER_PWD
set head off 
set feedback off 
set echo off
:
:
:

Could you consider changing your test conditions from:-

Code:

if [ "X$FILE_NAME" == "X" ]

to

Code:

if [ -z "$FILE_NAME" ]                 # Is string null?

... .and

Code:

if [ $actual_size > $FILE_SIZE ]

to

Code:

if [ $actual_size -gt $FILE_SIZE ]     # Is 1st value greater than 2nd

To use this as an arithmetic comparison, you will have to be certain that both values are:-Perhaps this may help:-

Code:

typeset -i actual_size FILE_SIZE

You script will report an error if you are assigning non-numeric to the variables listed, which may highlight the real source of the problem.



i hope that these suggestions help,

Robin
Liverpool/Blackburn
UK