UNIX for Dummies Questions & Answers

CREATE OR REPLACE
PROCEDURE gohan(num INT) IS

BEGIN
          DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
END;

sqlplus -s username/password<<END
execute gohan(7)
Commit;
exit;
END

sqlplus -s username/password<<END
set feed off serveroutput on
exec gohan(7)
END

value="$(
sqlplus -s username/password<<END
set feed off serveroutput on
exec gohan(7)
END
)"

value="$(sqlplus -s username/password<<END
set feed off serveroutput on
exec gohan(7)
END
)"