Discussion
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Answer: C
Correct answer: To see the errors, enter SHOW ERRORS in SQL*Plus.
SQL*Plus reports only that the procedure was created with compilation errors; the errors themselves must be asked for with SHOW ERRORS. The line numbers it then gives are counted from the start of the CREATE statement, which will not match a text editor’s numbering unless the statement begins on line one of the file.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development