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)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center