ALLBASE/SQL Message Manual (36216-90213)

124 Chapter4
ALLBASE/SQL Error Messages: 746-2100
PROCEDURE statement, and ensure that you use a
consistent parameter type in the parameter list. Then
reissue the EXECUTE PROCEDURE statement.
1143 MESSAGE Multiple values provided for single parameter
in the EXECUTE PROCEDURE statement. (DBERR
1143)
CAUSE You used the same parameter name more than once in a
named parameter list in the EXECUTE PROCEDURE
statement.
ACTION Correct the EXECUTE PROCEDURE statement, making
sure that each parameter name is assigned only one value.
Then reissue the EXECUTE PROCEDURE statement.
1144 MESSAGE The number of result columns defined exceeds
the maximum num of 1024. (DBERR 1144)
CAUSE You specified more that 1024 result columns in a CREATE
PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE statement, specifying
no more than 1024 result columns.
1145 MESSAGE Dynamic parameters are not allowed in
procedure statements. (DBERR 1145)
CAUSE You included a dynamic parameter in a statement inside a
parameter.
ACTION Reissue the CREATE PROCEDURE statement, omitting
any dynamic parameter.
1146 MESSAGE The WITH RESULT clause is allowed only for a
procedure returning results. (DBERR 1146)
CAUSE You included the WITH RESULT clause in a CREATE
PROCEDURE statement, but the procedure returns no
result sets.
ACTION Reissue the CREATE PROCEDURE statement, omitting
the WITH RESULT clause.
1147 MESSAGE DEFAULT clause is not allowed for an OUTPUT
ONLY parameter. (DBERR 1147)
CAUSE You provided a default value for an OUTPUT ONLY
parameter in the CREATE PROCEDURE statement.
ACTION Reissue the CREATE PROCEDURE statement, either
omitting the default value, or specifying OUTPUT rather
than OUTPUT ONLY.
1150 MESSAGE Host variables not allowed in CREATE RULE.
(DBERR 1150)
CAUSE You defined a RULE containing a host variable.