1 Reply Latest reply: Apr 17, 2012 2:06 AM by 906445 RSS

    FNDGFU

    560669
      hi

      I am using the below shell script to execute the below

      v_file_id=$1
      v_file_name=$2
      FNDGFU apps/apps 0 Y DOWNLOAD=$v_file_id /tmp/$v_file_name

      once i execute the file getting the message as below


      Log filename : L5846630.log


      Report filename : O5846630.out
      ORA-01722: invalid number


      log file does not have any information on the error.

      ----------------------------------------------------
      If i hard code the values

      v_file_id=213445
      v_file_nam=Test.pdf
      FNDGFU apps/apps 0 Y DOWNLOAD=$v_file_id /tmp/$v_file_name

      the file is not downloading

      --------------------------------------------------

      but
      if i try as below

      v_file_id=$1
      v_file_name=$2
      FNDGFU apps/apps 0 Y DOWNLOAD=213445 /tmp/$v_file_name


      the file Test.pdf is downloaded in the dir /tmp but it is appended up ?


      any suggestion

      Regards
      Yram
        • 1. Re: FNDGFU
          906445
          v_file_id=$1
          v_file_name=$2

          mv /tmp/$v_file_name /tmp/bkp$v_file_name #rename the file

          FNDGFU apps/apps 0 Y DOWNLOAD=213445 /tmp/$v_file_name

          Now it will not be appened.