Shell Programming and Scripting

#!/bin/bash 
shellvar=`sqlplus -s <<EOF
execute test();
commit;
exit;
EOF`
echo $shellvar
mail -s "email title" myemail@test.com <<< "$shellvar rows inserted"

create or replace procedure test (oRes OUT number) IS

begin

oRes:=1;

EXCEPTION
    WHEN OTHERS THEN
    raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
end;

#!/bin/bash
shellvar=`sqlplus -s <<EOF
select test() from dual;
commit;
exit;
EOF`
echo $shellvar
mail -s "email title" myemail@test.com <<< "$shellvar rows inserted"

create or replace function test return number IS

oRes number;
begin

select 1 into oRes from dual;

return oRes;
EXCEPTION
    WHEN OTHERS THEN
    raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
end;