connect &2
-- If you want to spool output into log files:
spool &1

-- If you want to see commands in log files:
set echo on

-- Commands to be executed

begin
  my_package.my_procedure;
end; 
/

spool off
exit

@echo on

set SCRIPT=C:\temp\my_script.sql

if not exist %SCRIPT% goto END

start sqlplus.exe /nolog @%SCRIPT% %SCRIPT%.server1.log "SERVER1_USERNAME"/"SERVER1_PASSWORD"@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ser1)))
start sqlplus.exe /nolog @%SCRIPT% %SCRIPT%.server2.log "SERVER2_USERNAME"/"SERVER2_PASSWORD"@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=y.y.y.y)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ser2)))
start sqlplus.exe /nolog @%SCRIPT% %SCRIPT%.server3.log "SERVER3_USERNAME"/"SERVER3_PASSWORD"@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=z.z.z.z)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ser3)))
start sqlplus.exe /nolog @%SCRIPT% %SCRIPT%.server4.log "SERVER4_USERNAME"/"SERVER4_PASSWORD"@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=w.w.w.w)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ser4)))

:END