Toad World® Forums

SQL Nav does not display Oracle errors


#1

Sample SQL:

SELECT ROWNUM / ROWNUM
FROM DUAL
CONNECT BY LEVEL <= 500
UNION ALL
SELECT 1 / 0
FROM DUAL
UNION ALL
SELECT ROWNUM / ROWNUM
FROM DUAL
CONNECT BY LEVEL <= 500

Execute the script in SQL Nav 6.2 or 6.3 Beta, click the Fetch All button. The SQL Nav shows 501 records and stops the script execution. No error, no nothing.

SQL Nav 5.5 shows:
ORA-01476: divisor is equal to zero

A simplified SQL like this
SELECT 1 / 0 FROM DUAL

results a correct error displayed.

So it is hard if


#2

Hi Alexey,

Sorry for my late reply. A CR has been raised for this issue.

Gwen