Your procedure has no transaction at all, so there could be cases where only part of the procedure will be committed.

If the procedure will encounter a run time error it will raise the error. Depending on the error’s severity it might continue to the next statement or stop running the procedure but continue work with its session or kill the session. In very rare and extreme cases with very high severity it can stop the server (but I only read about such cases and never encountered any). In short it all depends on the severity of the error that you’ll get.

Adi