Access violation error occurs with SQL Statement that does a divide by 0.
Run the below query using F9Customer gets it immediately. Using F5, you get the ORA-01476. The OCI buffer set to 500.
SELECT 10 / v calc
FROM (SELECT DBMS_RANDOM.random v
FROM all_objects
WHERE ROWNUM < 1000
UNION ALL
SELECT 0 FROM DUAL
UNION ALL
SELECT DBMS_RANDOM.random
FROM all_objects
WHERE ROWNUM < 10)
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center