In oracle sql developer if I manually click run next to a stored procedure, then it will generates code like:
Begin
execute mysproc;
End;
My question is : will above command will automatically commit all transactions in the stored procedure even I don't have a commit statement below the execute my sproc statement?
and will it also rollback all the transactions in the stored procedure if any errors happened -even I don't explicitly have a roll back statement?
Thanks