In SQL Developer I can run a query that returns 2,689 rows, however when I paste the same query (with the same connection) into the VSCode and Run Statement, it returns no rows in the query result window. The weird thing is that if I click "Run in SQLcl" then it returns all the right information to the terminal, however not in a useful format that I can export.
This does not happen for all queries. Some queries do return as intended to the Query Result screen; however, some return to the Query Result screen with the incorrect number of rows or content. The types of data that I'm accessing in the query that returns nothing to queries where we're joining to tables several thousand records. It's an Oracle EBS database, specifically a base table.