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

When a PL/SQL procedure has compilation errors, SQL*Plus displays a warning message but does not automatically show the errors. The DBA or developer must explicitly execute the 'SHOW ERRORS' command to view the compilation error details, including line numbers and error messages. Option A is incorrect because SQL*Plus renumbers lines starting from 1, not matching your editor. Option B is false because errors aren't shown automatically. Option D is incorrect - successful compilation produces no warning message.

Keep practicing — related questions