Oracle Developer is famous for its rapid data processing and development, and its exception handling mechanism is also relatively complete.
1. Advantages of exceptions
If no exception occursProgramCheck whether each command succeeds or fails,
PL/SQL exceptions
The pre-defined exceptions and codes of PL/SQL are as follows:Exception Oracle error sqlcode Value MeaningAccess_into_null ORA-06530-6530 the referenced object is assigned directly to the object without InitializationCase_not_found
Abnormal
Oracle Error number
Sqlcode value
Throw the opportunity
Access_into_null
ORA-06530
-6530
The program attempts to assign a value to an uninitialized (automatically assigned null) object's
Recently work a little busy, there is no time to study in the work time, I sometimes go to play ball at night, go home to watch TV dramas, Days are passing by. A while ago I saw that the company was useful to Oracle, and I always felt that Oracle
Exception handling:Even if a good Pl-sql program encounters errors or unforeseen events, a good program should be able to handle all kinds of error situations and recover as much as possible from the error. An error that occurs while the program is
Where can I start learning about Oracle? Here, I will take you to the door of Oracle. One chapter a day, seven days of entry is not a dream.
1. PL/SQL
PL/SQL is a procedural extension of Oracle in the standard SQL language that allows embedding
1.1 PL/SQL Introduction
PL/SQL is a procedural language of ORACLE, including a complete set of data types, condition structures, cyclic structures, and Exception Handling structures. PL/SQL can execute SQL statements, PL/SQL functions can also be
1. Definition
Exception: The identifier produced during the execution of the Pl/sql, and a warning or error in Pl/sql is called an exception.
Errors usually fall into two categories:
Compile-time errors-typically syntax errors, found by the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.