Re: [Firebird-odbc-devel] Error calling Stored Procedure

[Vladimir T. <pr...@hm...>]

Hello,

> The procedure on my Firebird 1.5 RC8 server has 2 input parameters
(integers) and 6 output parameters (numeric 15,2)
>
> SP_CALC_TOTDEBNR(103429,0,?,?,?,?,?,?)}\ 0"
>
> input values are 103429 and 0
> the 6 ? represent the 6 return values.
>
    Oooooooo! Yes! :-)
    I could not assume, that you will put Output parameters in limits ()
    You need to write much easier
Examples:
 {call SP_CALC_TOTDEBNR(103429,0)}\ 0"
or
 {call SP_CALC_TOTDEBNR(?,?)}\ 0"
- It is enough of it, and I am ready with you to argue, that for procedure,
which has a kind
===================================
create procedure "PROCAA"(  "A1"  integer,
                                                "A2"  integer,
                                                "A3"  float,
                                                "A4"  double precision,
                                                "A5"  numeric(4,0),
                                                "A6"  numeric(18,14))
      returns (  "B1"  integer,
                    "B2"  integer,
                    "B3"  float,
                    "B4"  double precision,
                    "B5"  numeric(4,0),
                    "B6"  numeric(18,14))
  as
BEGIN

  SUSPEND;
END
go
===================================
There should be a call {call PROCAA(?,?,?,?,?,?)}
===================================
My arguments:
    1) You can use this procedure in a call:
        select * from PROCAA(?,?,?,?,?,?)
    2) In server Firebird InOut Param will be possible  added
    3) If you will not execute SQLBindParam for output params,
anything bad will not take place, it will only your problem and desire!
    4) I have not found such rules in the specification!
==================================

Please,
    Your arguments???

--
Best regards,
Vladimir Tsvigun