Microframe Corporation 3007 Series Guía de usuario descargar pdf (Pagina 51)

1-43

-1000 to -5300

-4998: The operation parameter is invalid

See 1: The operation parameter is invalid.

-5022: Columns in the selection list and the returns

clause do not match

The number and type of columns specified in the selection list must

match the number and type of columns in the RETURNS clause. For

example, the following code returns error -5022 because the

RETURNS clause specifies one column but the SELECT list contains

two columns:

CREATE PROCEDURE p1 () RETURNS (c INTEGER) AS SELECT

c1, c2 FROM t1;

CALL p1()

-5025: Only IN parameter types allowed for user-defined

functions

A user-defined function (UDF) allows only IN parameters.

Parameters of type OUT and INOUT are not allowed. For example,

the following code returns an error because parameter “a” is

designated as “out”:

CREATE FUNCTION myfunc(OUT :a INTEGER)

RETURNS INTEGER

BEGIN

RETURN 1;

END;

-5027: Invalid Syntax. The last statement included within

a function must be a return statement

A user-defined function (UDF) must contain a RETURN statement

as the last statement in the function definition.

-5031: Default value cannot have the same UDF name as

the UDF being created

The name of a user-defined function (UDF) default parameter

cannot be the same name as the UDF itself. For example, the

following code is incorrect because both the UDF name and the

parameter name are “myfunc”:

1 2 ... 46 47 48 49 50 51 52 53 54 55 56 ... 251 252

Sin comentarios

Microframe Corporation 3007 Series Guía de usuario Pagina 51