Shell Programming and Scripting

#!/bin/bash -e
 
username=$1
pwd=$2
baza=$3
procedure=$4
var1=$5
var2=0
sqlplus -s -l $username/$pwd@$baza<<END
execute $procedure('$var1',$var2);
commit;
exit;
END
echo $var2

CREATE OR REPLACE procedure ttt(var1 in varchar2, var2 in out number) return number as

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

#!/bin/bash -e

username=$1
pwd=$2
baza=$3
procedure=$4
var1=$5

vvarr=$(sqlplus -s -l $username/$pwd@$baza<<END
set heading off;
set feedback off;
var var2 Number;
execute $procedure('$var1',:var2);
print var2;
commit;
exit;
END)
echo $vvarr
~