A stored procedure must declare each parameter passed to it. In addition, the TYPENAME column of the catalog table SYSIBM.SYSPARMS must contain a compatible SQL data type declaration for each parameter. For TYPENAME string and corresponding language declarations, see the SQL data types table in the appropriate precompiler manual.