Python 통한 데이터 전 처리 후, ORACLE DB에 Insert 할 때의 오류

Backend/Oracle 2023. 6. 5. 13:37

[Eloqua_sample_ver2 DB에 넣었을 때 Error]

SQL Error [12899] [72000]: ORA-12899: value too large for column →"YEON"."CS_INTEGRATION"."ex" (actual: 23, maximum: 20)

ORA-12899: value too large for column "YEON"."CS_INTEGRATION"."ex" (actual: 23, maximum: 20)

—> varchar2의 크기를 (30)으로 수정해서 해결

Happiness can be found even in the dark Happiness can be found even in the dark