I'm new to Oracle so apologies if this is simply user error, but there's a difference in the way SQL Developer for VS Code handles the below when compared to SQL Developer Classic.
If a simple query has the terminating semicolon on the next line after the script, and the cursor is after the semicolon, hitting Ctrl+Enter to run the statement in VS Code results in “An error occurred while running the statement”.
E.g. with this query with the cursor at the end of line 4:
Hit Ctrl+Enter:
In SQL Developer Classic, under the exact same circumstances, the query runs without a problem.
In VS Code if the cursor was placed at the end of line 3 before hitting Ctrl-Enter, the query will run. Why does it fail if the cursor is at the end of line 4? Shouldn't it run the query that precedes the semicolon, like it does in SQL Developer Classic?
This is on version 25.1.0.