Methods for handling uncertainty in trigger return results

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. ...

AI Technical Summary

Problems solved by technology

[0006] In actual work, some businesses involving databases not only have a heavy workload, but also deal with various data and relationships very complicated. There are many fields in the data table. If it is handed over to the background for processing, it will be processed quickly without the database. The uncertainty of the cursor return value when designing triggers often leads to program errors on the database side, which affects the smooth flow of the system. In addition, the database programming language is not as concise and clear as a high-level language, and many developers will give up programming on the database side. Development, and turn the work to the background, which will increase the load on the background, let the powerful database be idle, and only process some SQL statements

[0007] The so-called uncertainty of the return value of the cursor result means that when a result set is returned, sometimes it is one result, sometimes it is multiple results. When multiple results are encountered, an error will be reported when using an implicit cursor. On the contrary, the same An error will be reported. There is no effective solution to this problem, and some database processing software does not have the function of debugging triggers, which makes the problem difficult

Images