Скачать или смотреть Resolving the PLS-00103 Error in PL/SQL Procedures

Discover how to fix the common `PLS-00103` error in your Oracle PL/SQL code. Learn to identify issues and implement effective solutions for your procedures.
---
This video is based on the question https://stackoverflow.com/q/62430223/ asked by the user 'Ellie' ( https://stackoverflow.com/u/13762913/ ) and on the answer https://stackoverflow.com/a/62432114/ provided by the user 'VN'sCorner' ( https://stackoverflow.com/u/2236726/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: PLS-00103: Encountered the symbol "END" when expecting one of the following: . ; The symbol ";" was substituted for "END" to continue

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Resolving the PLS-00103 Error in PL/SQL Procedures: A Step-by-Step Guide

Encountering errors while programming can be frustrating, especially when you're dealing with complex database procedures in PL/SQL. One common error you might stumble upon is the PLS-00103 error, indicating that the compiler found an unexpected symbol. This guide will guide you through understanding this error and how to resolve it effectively.

Understanding the Error

The specific error message you received was:

[[See Video to Reveal this Text or Code Snippet]]

This error typically occurs due to syntax issues or logic errors in your PL/SQL code. In your case, the procedure you wrote had multiple problems which we will address step-by-step.

Common Issues Identified

After reviewing the code you provided, several underlying issues contributed to the PLS-00103 error:

Unused Input Parameters: The input parameters IDPELATH and IDTHLEFWNO were declared but not utilized within the procedure body.

Cursor Fetching: The fetch operation was attempting to retrieve a single record from a cursor designed to potentially handle multiple records.

Incorrect Exception Handling: The raise_application_error function required two arguments, but it was not used correctly in your code.

A Corrected Version of Your Procedure

Below is a revised version of your procedure that incorporates the necessary fixes to resolve the error and fulfill its purpose:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Changes Made

Utilization of Input Parameters: Both IDPELATH and IDTHLEFWNO are now used in the SELECT statement to count how many phone numbers correspond to the received IDPELATH and IDTHLEFWNO.

Proper Cursor Management: Instead of using a cursor, we directly counted records matching the criteria, simplifying your logic.

Corrected Exception Handling: The raise_application_error function is used properly with appropriate error messages and SQL error codes.

Conclusion

By addressing these issues, you should be able to eliminate the PLS-00103 error from your PL/SQL procedures. Remember that thorough testing and debugging practices are essential in programming to ensure that your database interactions behave as expected. If you encounter any further issues or have additional questions, feel free to reach out for assistance.

Happy coding!