Shell Programming and Scripting

#!/bin/sh
TERM=vt100
export TERM
WORKDIR=/mnt/sr_scripts/PER
export WORKDIR
cd $WORKDIR
 
DEV="dev" #this is dev environment.
TEST="test" #this is TEST environment.
 
echo "Enter Environment"
read mENV
echo "Enter a valid PERSON_ID for the employee:"
read PID
echo "Display Payroll Element Entries (Y|N):"
read PEE

if [ "$mENV" == "$DEV" ]; then
 sqlplus -silent apps/apps @PER12.sql
 expect "Enter a valid PERSON_ID for the employee:"
 send "$PID"
 expect "Display Payroll Element Entries (Y|N):"
 send "$PEE"
elif [ "$mENV" == "$TEST" ]; then
 sqlplus -silent apps/apps123 @PER12.sql
 expect "Enter a valid PERSON_ID for the employee:"
 send "$PID"
 expect "Display Payroll Element Entries (Y|N):"
 send "$PEE"
fi

$
$
$ cat -n per12.sql
     1  begin
     2    dbms_output.put_line ('You entered PID = ' || '&1');
     3    dbms_output.put_line ('You entered PEE = ' || '&2');
     4  end;
     5  /
     6
$
$
$ cat -n myscript.sh
     1  #!/bin/bash
     2  TERM=vt100
     3  export TERM
     4  WORKDIR=/mnt/sr_scripts/PER
     5  export WORKDIR
     6  #cd $WORKDIR
     7
     8  DEV="dev" #this is dev environment.
     9  TEST="test" #this is TEST environment.
    10
    11  echo "Enter Environment"
    12  read mENV
    13  echo "Enter a valid PERSON_ID for the employee:"
    14  read PID
    15  echo "Display Payroll Element Entries (Y|N):"
    16  read PEE
    17
    18  if [ "$mENV" == "$DEV" ]; then
    19    LOGIN="apps/apps"
    20  elif [ "$mENV" == "$TEST" ]; then
    21    LOGIN="apps/apps123"
    22  fi
    23
    24  sqlplus -silent $LOGIN @per12.sql $PID $PEE <<EOF
    25    -- other stuff that you may want to do in sqlplus here...
    26    exit
    27  EOF
    28
$
$
$ ./myscript.sh
Enter Environment
dev
Enter a valid PERSON_ID for the employee:
100
Display Payroll Element Entries (Y|N):
Y
old   2:   dbms_output.put_line ('You entered PID = ' || '&1');
new   2:   dbms_output.put_line ('You entered PID = ' || '100');
old   3:   dbms_output.put_line ('You entered PEE = ' || '&2');
new   3:   dbms_output.put_line ('You entered PEE = ' || 'Y');
You entered PID = 100
You entered PEE = Y
 
PL/SQL procedure successfully completed.
 
Elapsed: 00:00:00.21
$
$
$ ./myscript.sh
Enter Environment
test
Enter a valid PERSON_ID for the employee:
200
Display Payroll Element Entries (Y|N):
N
old   2:   dbms_output.put_line ('You entered PID = ' || '&1');
new   2:   dbms_output.put_line ('You entered PID = ' || '200');
old   3:   dbms_output.put_line ('You entered PEE = ' || '&2');
new   3:   dbms_output.put_line ('You entered PEE = ' || 'N');
You entered PID = 200
You entered PEE = N
 
PL/SQL procedure successfully completed.
 
Elapsed: 00:00:00.21
$
$