ALLBASE/SQL Message Manual (36216-90213)

122 Chapter4
ALLBASE/SQL Error Messages: 746-2100
ACTION Check the SELECT portion of your DECLARE CURSOR
statement to make sure there is no INTO clause, and
reissue the CREATE PROCEDURE statement. Use the
INTO clause in the FETCH statement.
1134 MESSAGE Local variable data type is invalid. (DBERR
1134)
CAUSE You attempted to use a non-integer local variable or
parameter in a SAVEPOINT, ROLLBACK WORK TO
SAVEPOINT, or SET TIMEOUT statement in a procedure.
ACTION Correct the data type for the local variable or parameter
and reissue the CREATE PROCEDURE statement.
1135 MESSAGE A local variable/host variable is not allowed
in an inner query block. (DBERR 1135)
CAUSE You attempted to use a local or host variable in a nested
query block or in any query block in a UNION other than
the first UNION block.
ACTION Remove the illegal variable reference in the query.
1136 MESSAGE The number of parameters defined exceeds the
maximum of 255. (DBERR 1136)
CAUSE You attempted to specify more than the maximum of 255
parameters in a CREATE PROCEDURE or EXECUTE
PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE or EXECUTE
PROCEDURE statement using 255 or fewer parameters.
1137 MESSAGE The expression in a variable or parameter
assignment statement contains an element that
is not allowed in a stored procedure. (DBERR
1137)
CAUSE You used one of the following elements, which are not
allowed in the expression of an assignment statement in a
procedure: column reference, subquery, dynamic
parameter, aggregate function, TID function, long column
function, or date/time conversion function involving a
column reference.
ACTION Reissue the CREATE PROCEDURE statement ,
eliminating the illegal elements from the expression.
1138 MESSAGE The expression in an actual parameter
contains an element that is not allowed in
the EXECUTE PROCEDURE statement. (DBERR 1138)
CAUSE The following elements are not allowed in an expression in
an actual parameter in the EXECUTE PROCEDURE
statement: column reference, subquery, dynamic