call sql oracle 8.i with unix script fails

From: Ed Yin <vraagme_at_hotmail.nl>
Date: Fri, 12 Jan 2007 19:45:44 +0100
Message-ID: <4abdb$45a7d753$50398baa$18065@news.chello.nl>

hello,

maybe someone can help me out on this script it will only execute 1 sql statement depending on what file_name what is wrong with what i am trying to do?

i try to call a sql like this depending on interface type

    this shell is called rim started like this ./rim POR AL where POR is type en AL = $2 file name in this test

      $1=INTTYPE
      file_name='test.por'
      typeO=ORD
      typeP=POR

      if  $1=$typeO
           then
       sqlplus -s / @ord_controle.sql $2 $file_name <<F /
        echo processing $typeO $1 $sql1 $file_name
        else $1=$typeP
        sqlplus -s / @por_controle.sql $2 $file_name <<F /
        echo processing $typeP $1 $sql2 $file_name

show errors;
F

   fi
exit 0

thanks Ed Received on Fri Jan 12 2007 - 12:45:44 CST