ProC and ANSI Dynamic SQL

From: Robert J. Rubin <rubin_at_no-spam-istation.com>
Date: Wed, 8 Sep 1999 10:52:49 -0500
Message-ID: <GBvB3.12874$Ik5.120808_at_dfw-read.news.verio.net>



Is there a way to dynamically determine the scale and precision of a database type "number" using ANSI Dynamic SQL in ProC?

The ProC documentation shows how to do it via Oracle Method 4 but not ANSI.

GET DESCRIPTOR returns ANSI type '2' (NUMERIC) for all numbers and floats. Unfortunately, the LENGTH attribute is returned as 38 (bytes) and 126 (bits). But since the TYPE is always 2, how do I differentiate?

Thanks,

    -Robert Received on Wed Sep 08 1999 - 17:52:49 CEST

Original text of this message