SQL & PL/SQL

Hi,

I am updating a table in one schema with data from a different schema in the same database

using following sample code

select substr(source_tbl_data, 1, 30) in cursor

& update trgt_tbl using cursor

. i am getting the ora-12899 value too large for column error. The char set is UTF 8 for the database.

I can not alter the column datatype from bytes to char, since the table is being used in many other places.

Can you suggest any alternative

Thank you