This relates to Toad for Oracle Beta 184.108.40.206 - but has been around for a while.
I have an extremely large and complex SQL statement - please see attachment below.
When I change something and inadvertently introduce an error, Oracle will throw an error at me - which is fine.
Toad then repositions the editor so that the cursor is placed on the error line.
Unfortunately, with large/complex queries Toad selects the wrong line.
In the attached query, the error is somewhere in lines 2053-2086 - that’s the section I changed…
When I hit F9, I get error:
ORA-00904: “RTN”.“ROUTINE_TYPE”: invalid identifier
and the editor repositions to line 819.
Assuming Oracle reports the last occurrence it would be off by 1260 lines.
I’m not sure it’s a Toad error - it might just as well be an Oracle error (this is running on Oracle 9…)
If you’d like additional info, please do let me know.
Please mind this .png file is actually a .zip file holding the query and the table definitions. You’ll miss the data, but that should make no difference…