Conference orarep::nomahs::odbc_rdb_driver

1303.0. "Stored procedures & Delphi variables" by ukvms3.uk.oracle.com::LWILES (Louise Wiles, UK Rdb support) Wed Feb 19 1997 15:25

    Hi,

    ODBC V2.10.
    Rdb7
    SQL/Services V7.0

    A customer of mine has a problem with a stored procedure & Borland's
    Delphi.

    He gets the wrong values returned, and the value returned depends on
    the datatype & how the variable is declared in Delphi.

    If he is expecting a varchar back, and he declares it in Delphi as a
    string output, the value will be NULL; if the variable is declared as a
    string input/output, the value will be blank

    If he is expecting an integer, and he declares the Delphi parameter as
    an integer output, the value will be NULL.

    If he's expecting an integer & a float back, and he declares the two as
    input/output, their values appear to get swapped, ie the integer should
    be getting 123, but gets 65; the float should be getting 65.4321, but
    gets 123.

    I got him to enable client logging, and that shows the right values.
    Does this definitely mean that there's no problem with ODBC, & it's
    Delphi which is screwing things up?

    What else can I do to help him diagnose this problem?

    Thanks,
    Louise.
    float should be getting 65.4321, but gets 

    Sounds like a question for Borland...
    
    John