Method for handling uncertainty of return results of trigger

Abstract

The invention mainly provides a method for handling uncertainty of return results of a trigger, relating to the technical field of computer software. The method specifically includes the following steps that first of all, a variable is stated and is assigned; when processing a cursor, the variable value is changed according to different numbers of the return results through the corresponding abnormal handlings conducted to different return results in an Oracle database, for example, the variable is 1 at the beginning, when the cursor returns one result, the value remains unchanged, when the cursor returns a plurality of results, the variable value is assigned to be 2 and when the cursor returns no result, the variable value is assigned to be 0; and finally different program segments are executed with respect to different variable values by judging the sentences. In such a way, the return results are of clear structure and are simple and explicit, and therefore the trigger can accurately handle the return results of the cursor, the complicated problem is simplified and the expected target is accomplished. The invention aims to solve the technical problem of providing a method for handling the uncertainty of the return results of the trigger so as to ingeniously solve the problem of uncertainty of the return results of the trigger of a database by analyzing the results.

Description

technical field [0001] The invention relates to the technical field of computer software, in particular to a method for dealing with the uncertainty of trigger return results. Background technique [0002] With the rapid development of the current Internet, the requirements for data storage and communication have also increased dramatically, thus accelerating the continuous updating of database software. In the past, database software can generally only meet local data storage and access, and has the characteristics of small capacity and difficult interaction. With the continuous expansion of the network scale, people need a large-scale, distributed, mass-storage database management software. The oracle database software emerges as the times require, and is widely used in many large-scale network communication systems. Nowadays, some domestic enterprises often choose oracle database when developing application systems, so that they can meet their needs in different fields. ...

Images