Decimal Problem usind ADO and Microsoft Oracle ODBC driver
try using CDec instead of double. i'm not familiar with oracle data
types, so i'm assuming number is similar to the sql server numeric
data types which have a fixed precision and scale.
On Tue, 14 Mar 2000 18:41:15 -0500, "Kenneth Brannigan"
Quote:
>Hello I have a stored procedure in an Oracle 8.1.5 DB that accepts a
>parameter of NUMBER 22,4 When I call the proc I have a variant type which I
>convert to Double and set it to the input parameter:
>.Parameter(viInput") = CDbl(InputField)
>When I execute the stored proc it chopes off the decimal portion. Can
>someone tell me how I can get this to work?? If I debug I can see the write
>value is in the parameter before execution but still the decimal is chopped
>in the DB.
>Thanks,
>Ken
