Note: the output values of RETCODE and RETDESC here do not need to be selected in the function; Because even if there is no, it will automatically return to the Object/Map) after successful execution, so there is no need to select in the function.

To execute a function in Navicat, you need to input a parameter value, which also corresponds to the diagram 1, and @A@B represents the output value. (one input value and two output values)

1. If there are one, two, three, four and five digits, the results returned after successful execution are as follows.

Mark a corresponding result 1.

Label 2 corresponds to result 2.

Mark 3 corresponds to result 3.

Label 4 corresponds to result 4.

Label 5 corresponds to result 5.

Where result 3 returns a set.

There are so many results that the set in result 3 is not easy to get, and only one result can get the set as shown in the following figure.

2. If the tag 1245 does not exist, the result returned after successful execution is as follows.

Only the result is 1, corresponding to the values marked in three places. You can take out the collection.

Function p_duplicate_enroll