Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: XSU (XML utility) and value larger than specified precision allows por this column

Re: XSU (XML utility) and value larger than specified precision allows por this column

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 22 Jul 2002 21:56:16 -0500
Message-ID: <uvg77rngv.fsf@hotpop.com>


On Mon, 22 Jul 2002, jluque_at_redprint.com wrote:
>
> Hi:
>
> I'm using XSU12 (XML Utility) with Oracle8i, on a W2K
> server. When I try to save data into a field that contains a
> number (NUMBER(10, 0)), I get ORA-01438: value larger than
> specified precision allows for this column. However, if I do it
> with an INSERT sentence from SQL-Plus, it works perfectly.

I got the same behaviour from XSQL which probably uses the same engine. I just changed the definition of the resulting table. :-(

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Mon Jul 22 2002 - 21:56:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US