Finding the right line when Oracle says an error happens at a line number.
819570Jun 10 2011 — edited Jun 10 2011Hi,
Were using Oracle 11.1.
I use TOAD 10 to develop.
When I run a procedure sometimes I'll get an error message saying "an Oracle error happened at ### line number"
When I go to that line number, that's usually not where the error is.
I'm not talking about an error where they say it occurs at line 1.
It'll say line 124 and in the TOAD editor that will occur in the middle of a cursor or something.
I'm pretty sure that's not where the error actually is.
Is there any way to find out where Oracle is talking about?
Thanks!