How do I pass a return code from Oracle SQL script back to the batch script which called it?

Question

I'm running Windows 10-64 bit and Oracle 18.4 I have a Windows batch file (test1.bat) which calls a windows SQL script file.

SQLPLUS -s (username)/(password) as sysdba @test1.sql
Echo %errorlevel%

I would then like to do some error checking on the %errorlevel% variable when I'm returned to Test1.bat from SQLPLUS. I'll create different processes depending on whether the return code is ORA-01940 (Cannot drop a user that is currently connected) or ORA-01918 (user 'MYUSER' does not exist), etc.

When I run test1.bat, I can't reference the return code from Oracle SQLPLUS, even when the user was previously dropped. The batch script generates

>Echo 0
0

How can I pass the error code from Oracle SQLPLUS back to the batch script which called it? Here's the test1.sql

PROMPT Begin Dropping User Schema MyUser
Alter Session Set CONTAINER=(MyContainer);
Alter Session Set "_oracle_script"=true;
DROP user MYUSER cascade;
Whenever sqlerror exit sql.sqlcode;
EXIT;

Hello Compo. I'm trying to understand why you closed this. The example you gave me is for a UNIX environment. I'm using Windows Batch. The UNIX example isn't helpful. Should I just resubmit the question again? — user3138025
Apologies, I had another question open in another tab and posted the wrong link. Unfortunately I cannot locate it again at the moment, so have decided to reopen it until or if I do. — Compo
Does this answer your question? How do I pass a return code from an Oracle script back to the WINDOWS Batch script which called it? — Alex Poole
Hello Compo. I created a new discussion prior to your re-opening this one, so we have two discussions now. I think this one (stackoverflow.com/questions/59911257/…) can be deleted. However, please leave (stackoverflow.com/questions/59912822/…) intact it was already answered by Alex Poole and it's correct. — user3138025