Re: Problem with to_number in update
From: Jeff Piatt <member25196_at_dbforums.com>
Date: Wed, 19 Feb 2003 12:26:37 +0000
Message-ID: <2548068.1045657597_at_dbforums.com>
Date: Wed, 19 Feb 2003 12:26:37 +0000
Message-ID: <2548068.1045657597_at_dbforums.com>
Looks like the attribute DRUG_DOSAGE_NBR NUMBER(38) needs to have some scale defined in its type declaration, so that it will accept places to the right of the decimal point.
DRUG_DOSAGE_NBR NUMBER(10, 4) or whatever the case may be
that's the issue, I think, and not the column settings in SQL*Plus
-- Posted via http://dbforums.comReceived on Wed Feb 19 2003 - 13:26:37 CET