SQL*Plus does not execute SQL scripts that SQL Developer does
Remove the empty lines.
In sqlplus an empty line means stop previous statement and start a new one.
or you can set blank lines:
set sqlbl on
Remove the empty lines.
In sqlplus an empty line means stop previous statement and start a new one.
or you can set blank lines:
set sqlbl on