Shell Programming and Scripting

CREATE OR REPLACE function COMMON.t2(var1 in varchar2, vari in number,var2 in out number)  return number as

begin
    insert into korisnik_temp(kor_inicia, kor_opisno) values(1, var1);
    var2:=0;
    return var2;
exception
    when others then
    var2:=-1;
    return var2;
end;

username=$1
baza=$2
procedure=$3
var1=$4
prosao=0
passwd=''
vari=22
retval=0

echo $vari
while read line
do
        if [[ ! "$line" =~ ^# ]]; then
                tns="$(echo $line | cut -d: -f1)"
                login="$(echo $line | cut -d: -f2)"
                pwd="$(echo $line | cut -d: -f3)"
                if [ $login = $username ]
                then
                        if [ $tns = $baza ]
                        then
                                passwd=$pwd
                                prosao=1
                        fi
                fi
        fi
done < "connections"

if [ $prosao = 1 ]
then
        vvarr=$(sqlplus -s -l $username/$passwd@$baza<<END
        set heading off;
        set feedback off;
        var var2 Number;
        execute retval = $procedure('$var1', $vari, :var2);
        print var2;
        commit;
        exit;
        END)
        echo $vvarr
else
        echo -2
fi

Your line:
        END)
Should not have "END" indented and after looking at this a bit more closely
we should move the right parenthesis to the next line too:
END
)