Oct 2007: Error codes can be very puzzling

Include Toad-family sites

ORACLE

SQL SERVER

IBM DB2

MYSQL

SYBASE

CLOUD DB

Toad World
ORACLE
Steven Feuerstein's PL/SQL Obsession
Puzzles and Quizzes
Oct 2007: Error codes can be very puzzling

WELCOME, GUEST

Login / Register

Powered by Quest Software

Minimize

Toad World Puzzler - October 2007

Error codes can be very puzzling

There are several oddities in the world of Oracle regarding error codes. Answer the following questions to test your knowledge of these strange corners inside PL/SQL and Oracle.

1. Which of the following exception has two error codes associated with it?
A. TOO_MANY_ROWS
B. PROGRAM_ERROR
C. NO_DATA_FOUND
D. VALUE_ERROR

2. Which of the following features in PL/SQL saves or shows error codes as positive error numbers? In other words, if Oracle raised -2292, the error code will be saved as 2292?
A. DBMS_UTILITY.FORMAT_ERROR_STACK
B. FORALL with SAVE EXCEPTIONS
C. DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
D. SQLCODE

3. Which are the only non-negative numbers that Oracle uses for errors?
A. 0
B. 0 and 1
C. 0 and 1 and 100
D. None, all error numbers are negative

© 2010 Quest Software, All Rights Reserved. | Privacy Policy | Terms of Use | Contact Us | Send Feedback