Insert ino 'Getting error'

[syncdba]

Hi,
I'm working on Oracle 8i. I have created a table(Mapping_Currency) & trying to insert the values from another table Currency as

insert into mapping_currencies (currency,short_name)
select currency,alphanumericcode from currency.
I'm getting error:
ORA-01401: Inserted value to large for the Column.

I have changed Currency char(40) & Short_name varchar2(100).
Please let me know where I' wrong.

 

[SantaMufasa]

Sync,

Could you please post a "describe" of both the "MAPPING_CURRENCIES" table and the "CURRENCY" table?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[syncdba]

Currency Table
--------------
Currency Varchar2(90)
Alphanumericcode Varchar2(25)

Mapping_Currency
-----------------
Currency Char (40)
short_names 2(100)

 

[SantaMufasa]

Potentially, CURRENCY.CURRENCY is 50 characters larger than the target column MAPPING_CURRENCY.CURRENCY. To identify how many rows are disobeying the length limitation, you can issue this query:

select count(*) from currency
where length(currency)>40;

If the results exceed 0, then you must either substring only the first 40 characters from currency.currency, or expand the maximum length of MAPPING_CURRENCY.currency to a length >= the max(length(currency.currency)).

Also, what benefit do you expect from using a fixed-length column specification for MAPPING_CURRENCY.CURRENCY?


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.