#!/bin/bash
export LD_LIBRARY_PATH=/opt/oracle/product/ 10 . 2 /db/lib:/opt/oracle/product/ 10 . 2 /db/ctx/lib
export ORACLE_HOME=/opt/oracle/product/ 10 . 2 /db


SQLPLUS="${ORACLE_HOME}/bin/sqlplus"

command=`$SQLPLUS -S "/ as sysdba" <<EOF
@check_schema.sql;
EOF
`
echo $command

for name in "${variable}"; do
            start_it $name
        done

start_it()
{
  echo "Schema: $1"

   export ORACLE_HOME=/opt/oracle/product/ 10 . 2 /db
   SQLPLUS="${ORACLE_HOME}/bin/sqlplus"

   output=`$SQLPLUS -S "/ as sysdba" @check_schema.sql $ 1 `


  if [ $output = "1" ]; then
   $SQLPLUS -S "/ as sysdba" @ 1 .sql $ 1 
  else
   echo "Warning, schema doesn't exist"
  fi
}