Buenas quiero convertir un campo varchar a clob pero al momento de hacerlo sale que el string es muy largo, es decir, sobrepasa los 4000 bytes, dejo scritp para mayor vizualizacion.

Insert into SIDIN_CONSULTA.PROVINCIA
   (ID_DEPARTAMENTO, ID_PROVINCIA, COD_DEPARTAMENTO, COD_PROVINCIA, DES_PROVINCIA, COORD, CENTRO, ZOOM)
 Values
   (1, 1, ’01’, ’01’, ‘CHACHAPOYAS’,
    ‘-77.7327956119096 -6.45586759964466,-77.7391332369153 -6.46478409965296,-77.728843611906 -6.49411909968028,-77.7261782369037 -6.55205559973425,-77.706722111886 -6.55976822474146,-77.7076693618869 -6.57970597476,-77.6913768618721 -6.58608922476595,-77.6665453618495 -6.57826072475869,-77.6558732368398 -6.60366234978237,-77.6266641118132 -6.61274022479082,-77.6517734868361 -6.62998634980689,-77.662661861846 -6.65989984983472,-77.6796933618615 -6.67409572484793,-77.7016933618815 -6.67688672485051,-77.7159354868944 -6.65912309983397,-77.7389651119153 -6.64646884982216,-77.7456064869213 -6.66515822483957,-77.7395004869159 -6.71109972488236,-77.7480129869236 -6.7458243499147,-77.731897861909 -6.78346734994976,-77.7647489869388 -6.79975847496489,-77.7416848619179 -6.84058647500294,-77.7233248619013 -6.8934559750522,-77.7073087368868 -6.90884747506655,-77.7157606118945 -6.92120197507804,-77.7338163619108 -6.92857735008488,-77.738384486915 -6.9483433501033,-77.7589336119336 -6.96450785011833,-77.7792998619521 -6.94145272509683,-77.8019319869725 -6.96614447511982,-77.8343459870018 -6.95720572511146,-77.8421949870089 -6.97688485012979,-77.8803417370432 -6.96250385011635,-77.8986653620596 -6.98012422513273,-77.9286502370865 -6.98675935013887,-77.9398222370965 -6.97613672512896,-77.9618554871161 -6.9766426001294,-77.9835799871355 -6.96308997511676,-78.0011601121511 -6.97016460012329,-78.0008456121508 -6.94024485009544,-78.0141433621626 -6.93160272508737,-78.0006731121506 -6.91248347506959,-78.0060543621553 -6.89078410004938,-78.0014069871512 -6.88155922504078,-78.0071389871563 -6.87723272503675,-78.0014497371512 -6.86578272502609,-78.0110391121597 -6.85406135001517,-78.0309572371774 -6.84807397500956,-78.0140638621623 -6.82170672498502,-78.0210101121685 -6.8182563499818,-78.0226322371699 -6.7688782249358,-78.0307903621771 -6.7663972249335,-78.0381542371836 -6.74455072491314,-78.0088613621576 -6.74296484991171,-78.0010248621506 -6.72121184989148,-77.9595484871138 -6.71394759988475,-77.9418333620979 -6.70297522487457,-77.9359668620927 -6.6897890998623,-77.9186992370772 -6.68400784985695,-77.9084609870681 -6.6880293498607,-77.9013613620617 -6.67880472485209,-77.8548301120199 -6.67709572485058,-77.8020234869724 -6.65526172483031,-77.8139082369831 -6.63394722481044,-77.8112891119807 -6.61344122479133,-77.8303203619978 -6.56786134974887,-77.8274159869951 -6.54574997472829,-77.8637069870277 -6.47709959966432,-77.8608242370251 -6.44999409963908,-77.8771152370397 -6.42796484961855,-77.8744042370373 -6.41058784960237,-77.8883262370498 -6.4066992245987,-77.9047402370644 -6.38280659957646,-77.9058749870654 -6.36758197456228,-77.9194863620776 -6.36874809956334,-77.9258573620832 -6.35688472455229,-77.9321093620888 -6.33560547453244,-77.9271854870844 -6.32939259952667,-77.9377851120939 -6.30786909950661,-77.9338573620903 -6.29608597449565,-77.9412753620969 -6.2834960994839,-77.940236362096 -6.25922847446131,-77.9224354870801 -6.24539447444847,-77.9028242370625 -6.20807422441374,-77.9105136120694 -6.18056834938808,-77.891240237052 -6.10291409931582,-77.8760878620385 -6.10248822431541,-77.859898487024 -6.12055472433226,-77.8414492370074 -6.12864647433981,-77.7893808619605 -6.12289647433451,-77.8078104869771 -6.08093159929544,-77.8061367369756 -6.03154097424942,-77.7881054869593 -6.02809184924623,-77.7698682369428 -5.9665139741889,-77.7448339869201 -5.94494334916882,-77.7293984869062 -5.94264447416668,-77.7037266118829 -5.95290047417628,-77.6875644868683 -5.97909572420068,-77.6716748618538 -5.97410434919602,-77.6391398618242 -6.00107947422117,-77.5977078617865 -6.00441597422432,-77.5963616117853 -6.03333084925123,-77.586199486776 -6.03691659925456,-77.5651331117568 -6.02917784924738,-77.5547353617473 -6.05072872426744,-77.5422281117358 -6.05278784926938,-77.5211681117166 -6.08542609929979,-77.5065197367031 -6.08931284930342,-77.5093803617058 -6.1187292243308,-77.497600111695 -6.13282322434394,-77.4997352366969 -6.15400334936367,-77.4880691116862 -6.15860159936795,-77.4689833616687 -6.18464522439223,-77.5152997367112 -6.22503747442981,-77.5297597367245 -6.24570797444906,-77.5276958617226 -6.25895934946142,-77.540130736734 -6.28745434948795,-77.5548081117474 -6.302578224502,-77.5678828617594 -6.30946259950841,-77.5890097367787 -6.3044179745037,-77.6175734868047 -6.28075597448167,-77.6290872368153 -6.31374259951235,-77.6662408618491 -6.31839734951667,-77.6728228618551 -6.34132847453802,-77.6949086118752 -6.33501847453214,-77.7083481118873 -6.34095209953766,-77.7043101118837 -6.36147072455677,-77.7298554869069 -6.37161747456619,-77.7522632369272 -6.40355184959591,-77.7327956119096 -6.45586759964466’,DBMS_LOB.getlength(‘-77.7327956119096 -6.45586759964466,-77.7391332369153 -6.46478409965296,-77.728843611906 -6.49411909968028,-77.7261782369037 -6.55205559973425,-77.706722111886 -6.55976822474146,-77.7076693618869 -6.57970597476,-77.6913768618721 -6.58608922476595,-77.6665453618495 -6.57826072475869,-77.6558732368398 -6.60366234978237,-77.6266641118132 -6.61274022479082,-77.6517734868361 -6.62998634980689,-77.662661861846 -6.65989984983472,-77.6796933618615 -6.67409572484793,-77.7016933618815 -6.67688672485051,-77.7159354868944 -6.65912309983397,-77.7389651119153 -6.64646884982216,-77.7456064869213 -6.66515822483957,-77.7395004869159 -6.71109972488236,-77.7480129869236 -6.7458243499147,-77.731897861909 -6.78346734994976,-77.7647489869388 -6.79975847496489,-77.7416848619179 -6.84058647500294,-77.7233248619013 -6.8934559750522,-77.7073087368868 -6.90884747506655,-77.7157606118945 -6.92120197507804,-77.7338163619108 -6.92857735008488,-77.738384486915 -6.9483433501033,-77.7589336119336 -6.96450785011833,-77.7792998619521 -6.94145272509683,-77.8019319869725 -6.96614447511982,-77.8343459870018 -6.95720572511146,-77.8421949870089 -6.97688485012979,-77.8803417370432 -6.96250385011635,-77.8986653620596 -6.98012422513273,-77.9286502370865 -6.98675935013887,-77.9398222370965 -6.97613672512896,-77.9618554871161 -6.9766426001294,-77.9835799871355 -6.96308997511676,-78.0011601121511 -6.97016460012329,-78.0008456121508 -6.94024485009544,-78.0141433621626 -6.93160272508737,-78.0006731121506 -6.91248347506959,-78.0060543621553 -6.89078410004938,-78.0014069871512 -6.88155922504078,-78.0071389871563 -6.87723272503675,-78.0014497371512 -6.86578272502609,-78.0110391121597 -6.85406135001517,-78.0309572371774 -6.84807397500956,-78.0140638621623 -6.82170672498502,-78.0210101121685 -6.8182563499818,-78.0226322371699 -6.7688782249358,-78.0307903621771 -6.7663972249335,-78.0381542371836 -6.74455072491314,-78.0088613621576 -6.74296484991171,-78.0010248621506 -6.72121184989148,-77.9595484871138 -6.71394759988475,-77.9418333620979 -6.70297522487457,-77.9359668620927 -6.6897890998623,-77.9186992370772 -6.68400784985695,-77.9084609870681 -6.6880293498607,-77.9013613620617 -6.67880472485209,-77.8548301120199 -6.67709572485058,-77.8020234869724 -6.65526172483031,-77.8139082369831 -6.63394722481044,-77.8112891119807 -6.61344122479133,-77.8303203619978 -6.56786134974887,-77.8274159869951 -6.54574997472829,-77.8637069870277 -6.47709959966432,-77.8608242370251 -6.44999409963908,-77.8771152370397 -6.42796484961855,-77.8744042370373 -6.41058784960237,-77.8883262370498 -6.4066992245987,-77.9047402370644 -6.38280659957646,-77.9058749870654 -6.36758197456228,-77.9194863620776 -6.36874809956334,-77.9258573620832 -6.35688472455229,-77.9321093620888 -6.33560547453244,-77.9271854870844 -6.32939259952667,-77.9377851120939 -6.30786909950661,-77.9338573620903 -6.29608597449565,-77.9412753620969 -6.2834960994839,-77.940236362096 -6.25922847446131,-77.9224354870801 -6.24539447444847,-77.9028242370625 -6.20807422441374,-77.9105136120694 -6.18056834938808,-77.891240237052 -6.10291409931582,-77.8760878620385 -6.10248822431541,-77.859898487024 -6.12055472433226,-77.8414492370074 -6.12864647433981,-77.7893808619605 -6.12289647433451,-77.8078104869771 -6.08093159929544,-77.8061367369756 -6.03154097424942,-77.7881054869593 -6.02809184924623,-77.7698682369428 -5.9665139741889,-77.7448339869201 -5.94494334916882,-77.7293984869062 -5.94264447416668,-77.7037266118829 -5.95290047417628,-77.6875644868683 -5.97909572420068,-77.6716748618538 -5.97410434919602,-77.6391398618242 -6.00107947422117,-77.5977078617865 -6.00441597422432,-77.5963616117853 -6.03333084925123,-77.586199486776 -6.03691659925456,-77.5651331117568 -6.02917784924738,-77.5547353617473 -6.05072872426744,-77.5422281117358 -6.05278784926938,-77.5211681117166 -6.08542609929979,-77.5065197367031 -6.08931284930342,-77.5093803617058 -6.1187292243308,-77.497600111695 -6.13282322434394,-77.4997352366969 -6.15400334936367,-77.4880691116862 -6.15860159936795,-77.4689833616687 -6.18464522439223,-77.5152997367112 -6.22503747442981,-77.5297597367245 -6.24570797444906,-77.5276958617226 -6.25895934946142,-77.540130736734 -6.28745434948795,-77.5548081117474 -6.302578224502,-77.5678828617594 -6.30946259950841,-77.5890097367787 -6.3044179745037,-77.6175734868047 -6.28075597448167,-77.6290872368153 -6.31374259951235,-77.6662408618491 -6.31839734951667,-77.6728228618551 -6.34132847453802,-77.6949086118752 -6.33501847453214,-77.7083481118873 -6.34095209953766,-77.7043101118837 -6.36147072455677,-77.7298554869069 -6.37161747456619,-77.7522632369272 -6.40355184959591,-77.7327956119096 -6.45586759964466’, ‘-77.7753803360703 -6.44384598387838’, 9);