Trying to make the switch to SQL Developer for VS Code, but I'm getting an “An error occurred while running the statement” a lot for when I know the simplistic statement is fine. It's not giving me any more information that I can see. And yes, I know select * is not good programming practice, I'm just looking through some data not knowing what I'm looking for. If select * is buggy, I will have to abandon until fixed.
This is the statement that it's having issues with.
select * from invoice_header where NOT_SELECTED_DATE IS NOT NULL order by invoice_id desc
This works fine:
select invoice_id from invoice_header where NOT_SELECTED_DATE IS NOT NULL order by invoice_id desc