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

Home -> Community -> Usenet -> c.d.o.misc -> NUMBER to CHAR conversion

NUMBER to CHAR conversion

From: Alec Perminov <V.Prosekin_at_vaz.ru>
Date: Thu, 6 Apr 2000 10:21:54 +0400
Message-ID: <8ch706$8ha$1@ss20.vaz.ru>


Can anybody help me?
Why the statement:

INSERT INTO sample_table VALUES(TO_CHAR(1,'00'));

returns error:

ERROR at line 1:
ORA-01401: inserted value too large for column

There is 'sample_field' CHAR(2) in 'sample_table'. I thought the statement have
to write value '01' in the field. But it does not work. Why?

Alec. Received on Thu Apr 06 2000 - 01:21:54 CDT

Original text of this message

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