Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    34

    Unanswered: What is the mistake in it?

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

    Re: What is the mistake in it?

    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

    Originally posted by asram
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •