Cannot update data on a table
I have loaded some data in a temp table . Then I have written a script to update data from temp to main table. But i am getting an error invalid number.
Data type in temp table is varchar
Data type in main table is number
begin
FOR C IN (select ITEM_CODE ,FJAN ,FFEB ,FMAR ,FAPR ,FMAY ,FJUN ,FJUL ,FAUG ,FSEP,FOCT ,FNOV ,FDEC from grays_sales_forecasts_temp)
LOOP
update grays_sales_forecasts_t
set FDEC = to_number(c.FDEC)
where ITEM_CODE = C.ITEM_CODE;
END LOOP;
end ;
MC0cZgtHwLLsG3bC3iGwdwjsGQKKIVAwCHYNgvwBkDcAcvtBTj8vte22UrNxGfe+cSEypy5Ls3OZAaQYQHIHm9zBJOmYRB0t09IJ7VRcKxnbQsQ041FNeGQTFtloiWi0hDdYwurRsHrbiowTmaCzIDXHchWZCg2wReoyP+sFtyJTYr5KbL1KwJXIbKRmbzRXUhN0RnA6ixR0Fq8jY9rJqFYyrJkMaSKDbHUmNZqd15at1BylJlZqNkZbmdRoqdQ4oyVIdJbQRia0WXV20E5nQo2WpLXWaHIOV0ZzrbOtbqXmqDNHo0l1tjKjOUgt+0dLzU5nO/tA1V/AfwbK/yXqq3/PH32r6C/vHL4v6syhRnNwWboOS9dhW/RYht6yVW/ZprdkdVh2GLBsA5bTieV2Yfnd2K5uS0GPRdFr2SOwt49nj2v2WsH29WGF/VjhAL5/kNg/RB4YpopH6OIR+uAI8/ko8/koc+gqe+gqe2gMuOHzq044eBUUj4LiUXBgFOwfAfuGwd5hsGcIFAyB3YO81HZKpMZXZ1KRiYgu63TuMqnI7FyW0gE267nqjEnUMZzO4tuouFYypoWIbsajmrCIBktEA6czS2g9GlrPi0x0WVCdgBrdpEaXr8ikIlOi/kpUFBmHr8riq7L4KS2uRLbeCW5F5lpnTqXmpyYCNMSGeiKokXCls+BGclMjpzMyQGM1mp3UVlSphTjte7qQ2rJ9T7FMs5Fam53UyIQ2svw6rzOZRGe80bQU3+UUCjROaqkGOtWqM95o0gJNqjM7o8UXVYeEy90Qv7/aUWp2OrMzmnudyQ5YH1F2oDq7z77lx+vs8Bg4o+n7f/4o/9fsvv/Yc/3tg9/Z6cyu1ykUZYLLMvTYVj2W2WHJMlh2dGLZnVhOF5bXhe3qxgp6sD29vIyKBrADA1jxIFY8aDk4aClejoNShrDPh/BDw8ShEeLwKHFklDp6lTo6Rh8bY46NMcfHmRMT7IkJ9sQ14IrjE845NgGOjYOj4+DwGPh8DBy8Cg6MgqIRsG8Y7BkGiiGwaxDkDYCcfrCzn+948l1OB51tce0ypyITupkgpQMkd4DkDpCkZ5P0bKKOSdDSCVo6vp2