ALLBASE/SQL Message Manual (36216-90213)

144 Chapter5
ALLBASE/SQL Error Messages: 2101-2419
2243 MESSAGE Execution of procedure of !.! was
invalidated. (DBERR 2243)
CAUSE The procedure executed a statement that invalidated any
further execution of the procedure, such as DROP
PROCEDURE or TRANSFER OWNERSHIP of the
procedure.
ACTION Modify the procedure definition if you did not intend to
invalidate the procedure during its execution. Otherwise,
no action is required.
2244 MESSAGE Invalid parameter name ! provided for
procedure !.!. (DBERR 2244)
CAUSE The name of a parameter in the EXECUTE PROCEDURE
statement is not defined in the parameter list of the
CREATE PROCEDURE statement.
ACTION Check the parameter lists of both the EXECUTE
PROCEDURE statement and the CREATE PROCEDURE
statement and ensure that the two lists match. Then
reissue the EXECUTE PROCEDURE statement.
2245 MESSAGE OUTPUT ONLY specified for a parameter not
declared as OUTPUT ONLY. (DBERR 2245)
CAUSE You specified OUTPUT ONLY for a parameter in an
EXECUTE PROCEDURE statement, but the parameter
was not declared OUTPUT ONLY in the CREATE
PROCEDURE statement.
ACTION Re-issue the EXECUTE PROCEDURE statement,
specifying OUTPUT instead of OUTPUT ONLY. Be sure to
initialize the parameter value.
2246 MESSAGE Number of items in select list does not match
number of result columns for procedure.
(DBERR 2246)
CAUSE The select list in a procedure SELECT statement with no
INTO clause is incompatible with the format specified in
the WITH RESULT clause of the CREATE PROCEDURE
statement.
ACTION Re-write the CREATE PROCEDURE statement, either
omitting the WITH RESULT clause, or ensuring that all
multiple row result sets returned from the procedure are
compatible with the format specified.
2247 MESSAGE The KEEP option is not allowed for a
procedure cursor. (DBERR 2247)
CAUSE The KEEP option was included on an OPEN cursor
command, but the cursor was defined on an EXECUTE
PROCEDURE statement.