Location of SQL error in PL/SQL Dev

[Ed Holloman]

Hello,

When I execute the following statement in SQL*Plus, the error text and line number along with the error number/description are displayed:

========================
SQL> SELECT SUM(e.ename)
2 FROM scott.emp e
3 /
SELECT SUM(e.ename)
*
ERROR at line 1:
ORA-01722: invalid number

SQL>
========================

When I do this in a Command window in PL/SQL Dev, I get this (error number/msg, but no line number, error line):

========================
SQL> SELECT SUM(e.ename)
2 FROM scott.emp e
3 /

SELECT SUM(e.ename)
FROM scott.emp e

ORA-01722: invalid number

SQL>
========================

Executed in a SQL window, the line number is not available either (and the cursor is left where it was, as opposed to taking me to the line number or highlighting the error line).

It the error information SQL*Plus is displaying not available inside PL/SQL Dev? In a more complicated statement that information is pretty useful.

Thanks,

Ed Holloman

 

[Marco Kalter]

This is a run-time error instead of a parsing error, so the error location is unkown. I'm not sure how SQL*Plus determines the error location.