Returns the specified value(s) from a result set procedure or a function.
RETURNstatement is used in a function to return the single value of the function.
The SQL statements in the body of the function are executed until a
RETURNstatement is executed. If the end of the function is encountered (because no
RETURNstatement has been executed) an exception is raised.
RETURNstatement is used in a result set procedure to return the value(s) of a row of the result-set to the calling cursor when
FETCHis executed for it.
FETCHis executed for a cursor calling a result set procedure, the SQL statements in the body of the result set procedure are executed until a
RETURNstatement is executed, then execution within the result set procedure is suspended until the next
Note: An array FETCH will cause more than one RETURN statement to be executed, so there is not necessarily a 1:1 correspondence between the number of FETCH statements executed and the number of RETURN statements executed.
If, following a
FETCH, the end of the result set procedure is encountered instead of a
NOT FOUNDexception is raised to indicate the end of the result-set.
RETURNstatement is used in a procedure, it must be a result-set procedure, see the Mimer SQL Programmer's Manual, Result Set Procedures.
If only one value expression is being returned, the parentheses are optional.
ExampleCREATE FUNCTION SQUARE_INTEGER(ROOT INTEGER) RETURNS INTEGER CONTAINS SQL BEGIN RETURN ROOT*ROOT; END
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40