Multiple choice

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

  1. The line numbers reported match the line numbers you see in your text editor.

  2. SQL*Plus will automatically show the errors to you.

  3. To see the errors, enter SHOW ERRORS in SQL*Plus.

  4. If there are no syntax errors, you will receive the message NO ERRORS.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

After creating a procedure with compilation errors, SQL*Plus displays a warning but doesn't automatically show the errors. You must explicitly type SHOW ERRORS (or SHO ERR) to see the error messages with line numbers. The line numbers in error messages often don't match text editor line numbers because Oracle counts differently. The message 'NO ERRORS' is never displayed for successful compilation.

Keep practicing — related questions