ls -lrt A*.txt | awk '{print $9}' | while read fname
do
sqlplus -S <<-END-OF-STD-INPUT-MARKER
  $db_user/$db_pass
var retval number;
DECLARE
v_retcode varchar2(100);
v_errbuf varchar2(100);
v_filepath varchar2(100);
v_fname varchar2(100);
BEGIN
v_filepath := '$dir';
v_fname := '$fname' ;
ECNI.PROCESS_INBOUND(v_retcode
                            ,v_errbuf
			    ,v_filepath
                            ,v_fname
                            );
:retval := v_errbuf;
END;
/
exit :retval;
END-OF-STD-INPUT-MARKER
if [ $? -ne 0 ]
then
  echo "Error while Importing "
  exit 1
else
mv $fname $archdir
echo The file $fname was successfully imported and moved from $dir to $archdir
fi