Re: Stored Procedure question

[Scott Mildenberger <scottmildenberger@xxxxxxxxx>]

If the 4th and 5th parameters are OUT parameters then
you have to receive their value into a variable when
you call the stored procedure.  Your call just passes
literals, change it to pass variables for these two
parms and you should be ok.

Scott Mildenberger

--- Mike.Crump@xxxxxxxxxxxxxxxx wrote:
> 
> Here is the code I used to generate the SP:
> 
> CREATE PROCEDURE SP(IN PROD CHAR(5), IN PRODSUFF
> CHAR(4), IN CUSTNO
>       CHAR(9), OUT PDFfile CHAR(128), OUT
> ReturnValue CHAR(1) )
>        LANGUAGE CL
>        NOT DETERMINISTIC
>        NO SQL
>        EXTERNAL NAME LIBRARY/PROGRAM
> 
> The calling program is a Notes agent and it is
> effectively doing this:
> 
> CALL QGPL.SP ( '05425','0601','407580601','
> ',' ')
> 


__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com