Execute procedure statement gives SQL error 674

Diagnosing The Problem

Execute procedure statement gives SQL error 674: Routine (tempproc) can not be resolved.

If the routine name is correct, you have specified correct number of arguments and you have the correct permissions to execute the routine, then the problem is that the data types for the arguments is not correct.

Example:

If you have a procedure,

CREATE PROCEDURE tempproc
(param1 integer,
param2 integer,
name varchar(30),
descript references text DEFAULT NULL
)
.
.
.

END PROCEDURE

and you execute the above procedure with:

execute procedure tempproc (2286992, 25, 'item5', 'TESTING');


You get error:

674: Routine (tempproc) can not be resolved.

You get the above error because of the last variable that is passed into the stored procedure.'descript' references text DEFAULT NULL. It is of type TEXT. If you define a variable for TEXT or BYTE data, the
variable is only a pointer to the data. You can't pass a string to a BLOB, it doesn't cast.