Oracle-L: truncating decimal places asp,ado 8.1.7.4

From: Michael Boligan <michael.boligan.b_at_bayer.com>
Date: Mon, 13 Oct 2003 08:34:25 -0800
Message-ID: <F001.005D2F28.20031013083425@fatcity.com>

List,

We went throught an 8.1.5.0. to 8.1.7.4.0 server upgrade only (no code changes, co app server changes oracle client 8.0), database server is AIX 4.3.3. Before the upgrade everything was working fine, now when variables with decimal places are passed from ASP to Oracle, they truncate the decimal places. Within oracle everything works fine, I can pass a parameter to a stored proc and the decimal is displayed and inserted into the table correctly.

The developers used the NUMERIC datatype in the stored procedures for datatypes with precision. It looks like the problem is with ADO (the only thing between asp and sqlnet).

Has anyone run into this before?

TIA,
Mike

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Michael Boligan
INET: michael.boligan.b_at_bayer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 13 2003 - 11:34:25 CDT