1 SELECT -----------
2 --
3 --
4 --
5 --
6 --
7 --
8 foo
9 FROM dual;
Executing the code above I get the error message "ORA-00904: "FOO": invalid identifier" and these results for error position and offset:
Execution method Error position and offset
-------------------------------------------------- -------------------------------------------------
SQL Developer 3.0.04 Control+Enter (run statement) Error at Line: 1 Column: 19
SQL Developer 3.0.04 Function-F5 (run script) Error at Command Line:6 Column:1
SQL*Plus 10.2.0 ERROR at line 7: (column 1 indicated by asterisk)
Only SQL*Plus identifies the error position and offset correctly. The error position is wrong by more than one line when using "run statement".
Q1: Is there some setting I should adjust to correct this behavior?
Q2: Does anyone know if this be fixed in a future release?
My apologies if this has already been discussed.
- Doug