I'm using UDB 8.1 on AIX 4.3........
db2 => call NUPROD.SP_GET_REPORT_PDF(7167)
DB21036E The CALL command failed.

CREATE PROCEDURE NUPROD.SP_GET_REPORT_PDF ( IN REPORT_ID int,
OUT REPORT_PDF blob(3000000) )
SPECIFIC NUPROD.GET_REPORT_PDF
RESULT SETS 1
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN


SELECT
NUPROD.PLAN_REPORT.DOCUMENT INTO REPORT_PDF
FROM
NUPROD.PLAN_REPORT
WHERE
(
( NUPROD.PLAN_REPORT.ID = SP_GET_REPORT_PDF.REPORT_ID )
);


END P1

Your problem is that you also have an out parameter. You are trying to call it with only one parameter. Try:

db2 => call NUPROD.SP_GET_REPORT_PDF(7167,?)

HTH

Andy