1, when OTHERS in the stored procedure what meaning.
There are many kinds of anomalies, such as No_found. Others should write the exception name, if you do not want to divide the exception so fine, you can use a general others to capture, that is, all the anomalies are captured with others.
2, ": =" stands for what.
": =" is an assignment symbol, such as: Name: ' Sky '.
3, SQLCODE
Sqlcode is the return code of the database operation, where 0--succeeds; -1--fails.
4, Raise_application_error
Raise_application_error can throw out a defined error message from a stored subroutine when used inside a subroutine.
The syntax is as follows:
Raise_application_error (Error_number, Error_message, [keep_errors]);
Error_number is a negative integer range between 20000 and-20999;
Error_message is a string with a maximum length of 2048 bytes;
Keep_errors is an optional Boolean value that indicates that the new error will be added to the list of errors that have been thrown, false to indicate that the new error will replace the current error list, and default to False.
5. CREATE or REPLACE PROCEDURE
Create OR REPLACE procedure means that a stored procedure that already exists in the database replaces it, and if not, creates a stored procedure.
Ing_ Work Suspense _oracle report