Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

best way to update a blob/clob column

Murray SobolJun 27 2019 — edited Jul 5 2019

I have a table defined as follows:

CREATE TABLE s1_document_template
(
   template_id                     varchar2(40)                not null,
   description                     varchar2(250)               not null,
   program_code                    varchar2(10)                not null,
   class_id                        varchar2(40)                not null,
   language_code                   varchar2(10)                not null,
   template                        blob                        not null,
   add_by                          varchar2(40)  DEFAULT user  not null,
   add_date                        date        DEFAULT sysdate not null,
   modified_by                     varchar2(40)                null,
   modified_date                   date                        null,
   default_template_flag           char(1)       DEFAULT 'N'   not null
       CONSTRAINT ckc_dt_default_template_flag CHECK (default_template_flag IN ('Y','N')),
   template_code                   varchar2(40)                not null,
   CONSTRAINT pk_document_template PRIMARY KEY (template_id)
       using index
       tablespace smartsoft_index
)
tablespace smartsoft_data
   LOB (template)
      STORE AS (TABLESPACE smartsoft_data
                ENABLE STORAGE IN ROW
                CHUNK 8192
                RETENTION
                NOCACHE
                LOGGING
               )
/

there is data present in this table; I need to update 1 row as follows:

UPDATE s1_document_template

   SET template = hextoraw('504B0304140002000800C069DB4EE278490A61010000B002000011000000646F6350726F70732F636F72652E786D6C8D52CD8E8230107E15C21DDAA2ABD820266AF6B426264BE2C65B53466C165AD216D167DBC33ED2BEC2020AD1AC873D4EBF9FF966A63F5FDFD1E25CE4CE09B4114ACE5DE263D701C9552A6436772B7BF042771147BCA45C69D86A5582B6028CD3C8A4A1299FBB476B4B8A5059E9DC573A432947904301D21A447C82DC816B4117E6A9A043EE9885B097129E527B70609F8D1888755DFBF5A8A3061813F4B1797BE747289827A4B14C72E855BC1C44A66318BF994D36E041E98259D399948C7FB20C5AB3092AC0B2945986DA5578E5B00B378E524EB90666958ED7AACA72669CDD5158309047E80E8C6E4BB83E40EA34E1E975D41ED98D56EBE4D58D034C661E9E78649690311D87F465B66FBD1EF4DD659A6E76D35CEC20205D5EE215D32A779695D6AA3611FA4BE8355B2D64EBD1770A7042423A1E5112EE075D4F1A921737A37F440FA60999D2263DC677D17B832E87869368BF5E1C4CBB9643DD558F7F2EFE05504B0304140002000800C069DB4EB1BE4AF8D5000000FE000000100000006D656469612F696D616765312E706E67EB0CF073E7E592E2626060E0F5F470096260602902B20538D880649545C43A20C592EEE8EBC8C0B0B19FFB4F222B90CF59E01159CCC0C0B7078419A7EE29F2040A2EF074710CA9887B7B6323E71107810307DEFEF1BAFF9CD9BA88517D06A3E9C248A00A06A11E1920D9C0A1CC0EA4140E9D6004521D0620EB189420521DE54FE61497A5A9784E02A292C0FFE99F0D8A201CBD73272682595D294F3C40022AAE465029A5DA3E90668677694F40948B8425881274E303920E2D139981D4840DBF99A53EF9F75C2EFC0EE23278BAFAB9AC734A680200504B0304140002000800C069DB4EB1BE4AF8D5000000FE000000100000006D656469612F696D616765322E706E67EB0CF073E7E592E2626060E0F5F470096260602902B20538D880649545C43A20C592EEE8EBC8C0B0B19FFB4F222B90CF59E01159CCC0C0B7078419A7EE29F2040A2EF074710CA9887B7B6323E71107810307DEFEF1BAFF9CD9BA88517D06A3E9C248A00A06A11E1920D9C0A1CC0EA4140E9D6004521D0620EB189420521DE54FE61497A5A9784E02A292C0FFE99F0D8A201CBD73272682595D294F3C40022AAE465029A5DA3E90668677694F40948B8425881274E303920E2D139981D4840DBF99A53EF9F75C2EFC0EE23278BAFAB9AC734A680200504B0304140002000800C069DB4EB1BE4AF8D5000000FE000000100000006D656469612F696D616765332E706E67EB0CF073E7E592E2626060E0F5F470096260602902B20538D880649545C43A20C592EEE8EBC8C0B0B19FFB4F222B90CF59E01159CCC0C0B7078419A7EE29F2040A2EF074710CA9887B7B6323E71107810307DEFEF1BAFF9CD9BA88517D06A3E9C248A00A06A11E1920D9C0A1CC0EA4140E9D6004521D0620EB189420521DE54FE61497A5A9784E02A292C0FFE99F0D8A201CBD73272682595D294F3C40022AAE465029A5DA3E90668677694F40948B8425881274E303920E2D139981D4840DBF99A53EF9F75C2EFC0EE23278BAFAB9AC734A680200504B0304140002000800C069DB4EBC4EE87C14010000A702000010000000776F72642F686561646572312E786D6CA5925D6A84301485B72279D7E8504A09EA3C4CA1F4B92BC8C4A8A12637DCC49FAEAD0F5D52B7D0E854850E9496790A21F77CF79C703EDF3FF2E3A4BB6890E814988264494A22690454CA3405E97D1D3F9063998FACAD300AA3C6B1B120ADF79651EA442B3577095869C25B0DA8B90F576CE808585904219D0B24DDD1439ADE53CD95212BC6BA2B905602C141ED13019A425D2B2117549067E90FE84BCBAD5C695AFCC595E6F8DADB38C02DF7EAAC3AE5DF16679BA92C0DA9D1B06F48BC399A45ECE288CD3E56C5F0DBFCA0BB3D6E76775BDE47E463387660731BEF09A1B73BEDFA03FF453B71337047222DD8736300F9B993059953AF2BAA69DB50C9414E168372413BC3EDCC3C5C0A32D7CD46B4CCE952BBF20B504B0304140002000800C069DB4E36B0EC20A71A00008C78020011000000776F72642F646F63756D656E742E786D6CED5DD972E3BA76FD15947CEA3CA4BA4D52A3A57B5B37767B68E7CA436C759F3C74550A2221893149B040C8437E2D0FF9A4FC42004E96655916259202ED7DAA4E8B23B800ECB5B0F70648FFDFFFFCEFDFFFF1E83AE89EB0C0A6DEB79AB1AFD710F14C6AD9DEE45B6DC6C75F0F6AFFE8FFFDA1675173E6128F2371BD17F41EBED5A69CFB3D4D0BCC297171B04F7DE2897363CA5CCCC52E9B680F94593EA3260902519CEB68755D6F6B2EB6BD5A528C1FBC2AC8B54D46033AE6FB2675353A1EDB26098B12B71BFA42A1B753EC93A434D75C07958BD9DDCCFF2A0AF731B747B663F3A710590ACAD045D599D78B0BF99A229237F522443D8923B9E37ED5F5F7AEF35C5DA3B95D7D8F197E103FCF054EB62BEF8CD199FF5CDAEB06CC54DA77ECDDE3A0865CB3773EF128C323877CABC95A278FB01ED32758E49E3CFA4CDC19161D78D89765D62303E9FFDD7AECC57689E42676BED544319A34C611B59EE4AF1FFE73CDE40F8B7F4EA9C703F4D0C38169DBDF6A433CA52EAE8903D3432F983B101614FCB73811166D1C8487B4B820EDB9DC8D0B1FA565BFF5B4879E83BD497290785F7FDECAC246B665CFED121CF0C3C0C6E9A1399C0F3DDE1F506CA12B661186F6E4091E9DDE0E7C3158A515F4021F9BC22C64D713764F6A7D541CEAE7678F1DEBFB1433946E0D9F7C81624426528EB4829F6E7B016743F2C8FBB797C393FF1846FD756EA1DF648CFE74F8DFE4FF97F41873FCE744EC89FFC5293296453CDFBB93160A888F19E6A4F846E27DA3B14353209E3557472D9197398DF92F3329D314432161F1A376213D87CCC60E3A72B07937F7841747DF13A166B3088A1401EC157B7E8951833897D4B53D3186532F64D37E74B4105295D8DC99F9560436DEFFF719211EBAC0EC099D9F676065892D552E61CB18CE0B763BEAF53CDD8EABC3E3AB9F43747673787C929B6CA7E8F5421D113C5A6D38AAF84CCB0D62C5D866450182D8F47BD833A79421CB0EF8306C50B975946E0DC4ED46B3A1C7BB37CFBB81EDFA0EB9A641782D238E10D97BF283D893290FED6A44A6B6671D5333BCC0A1E61DB1A24DFC4467FCDCFB4E9CA80FB1E3D0872BE1C83BD80F0F24A1C63AA15A5C9924725C1E0A85554D11A3C7F0294FA901F93D9F06B61C247EA4353965D41592409D99EBD5926BAEC6E380F0FED76EA7D3D5458BCE1F4C76A3725E94FA6BA15429DE1386FDE962C1CD837A7B65B9BFC21BC49024C36C53D4A3DD6E180DBD5543A6A84ED76836D32A91F19898FC24BA346A681EF555F8EF68AEF60F02CB25F548BC2BE2F86B866CD15B75A1B21E76858E5EDB269F3182EACDE426F3F2FE4CD6C1364F99B8449A16EE4DE68E0C449707C8A3428CBD09390C7C0127B48CA87BF106BD1BE505B4A84D5601D8F619734549D700CD98BD41517ED468A234B1D5F35358626BEBD2BC7BD125B2CE72473445D263AF3A2C6CAFE422794BD87EAF8A1839B67F6A3B0EB27C5B9A866C01792C86CCD6011C85FEC7711A28421D593EF582A9ED8BB09FF5883B924270431CDBC513128D40B81730F3461848BCC319E1E6546E8E05A6E4843677469B071D5521F0231B781C3357FE0A388B54C7923BAB88A33DDFEEB3809F11EA22B9F1ADC604885ADA76D1B3B4B85FC3FBE6EC657E3F32D6486743154EE537F3D0F28B300B7BF3634B7AA4F85485FA71F3F2CCC1EDE5E0FC76888E664F84DDCE5C5778AB435B0C46E2D9BF395220788E9B4918861DC86CD84FDF12AE7DE29B4588ACC7DE88D23B9997BCE5987199EE9274E7448C69E2EA73E9B98AA7CA71FAB1C7A320C1C3FE70E17C5264686C7CE4C43FB1C733726EF99343920A0C1357509CF84B1C7C1098F486519758A347588FF8F9924138AEA7E7C6F623B1E2B3D85AF038B5978F3D63B61597131D8A5B6C228E1F8E05F4971E9FF67C0537A37F93BD1867B3D3588AD23CA2320C0C423792722ED81D97ECD969E3CC5DA53D973DCF4F5F08D71123F8EE8808FD2368C11F7D0E291C32E68566008A734C973F497B6EF2E50DDF3C28B2E17759B56EA36B2CAB9B34D25B1F7BC9430ECAA9330C069B0F06DFC5D318362B3504ACADDA8D57AA7DD0692E97C357A28D679C8E6DBE2BD95E0E745B11663226DD611EB6EA544A32AA678C06C15F61847F317C2F818A7EFF81F6BEECEDEDEDEBBAAE00C5CA9BA2582B1399EBB3F34877BD239C48F4B89C4424163AA52C15507449F71512D0D22991B403CCD26D9A8C8FBD2E2D1A43B4747CDBF5BCFDC6EE557ECD9F3F8402356819497ECB5414AA250921244951AF0113D661426E3E55BBD5591A922D862D9D65610BA7FE62CCB2552C5362645CB5117638B50331C472647B72B02D9E2579D46917C371AE7DB1916F5B8DBE79CFA3AB582DFAE5061405B2A3E8D1A740E8150F6210BAA633CF0A3E73C832A77483A3B5A378051A4C31A7AD82C67F340BA6C401EB8FACFFE827E4B0F20B5BDE8C3F1A9D46739DF8234D5B17197F94307F9477FCD6D45B6BC56FADEAB6DF3646FCFE52C652B5280B9C25D944D7A596CD9FF62F65E2A4EC282487A6CC59A17240B48964B5EBADB524AB14CA55651EAB9C5799DE757276C08A12EA154FBDE00266AB3F9280CA66B2BDC93565FCBB905150D0FC15B4F2541271509866DD032AADA2D2AD891D122D94DCC1E4E62720D2164183BC207AD34282BD99C937A8311F485AD45298EDEEBA1186D16AAF15619412A1153843A4C6BB57300FB33A3F231C9D536C72CA82FDC95837FEF3D011F6EF856FCF84270778449C8F3143F3D1E707B495AF5B02BF81DF7A1DF85D25E8C06FE077267E3780DF55820EFC067E67E27713F85D25E8C06FE077267EB780DF55820EFC067E67E2771BF85D25E89BAC66E82E5FCC50D9450B2033CAE15E238D1F1EF9859D59B4AE0944442D1101FA027D5765E981BECA4007FA027DB326E181BECA4007FA027DB3E6D881BECA4007FA027DB3A6D081BECA4007FA027DB366C817E80B6971E5A06F9216375A8DF60EF3E230FB06DAA27760F6AD4AD061761DF89D89DF07C0EF2A41077E03BF33F1BB0BFCAE1274E037F03B0BBF0D1DF85D25E8C06FE077267EC3DBE595820EFC067E67E237BC5D5E29E8B0BA1D644641DC6BA4F161865F19E830C30FF4CD9AA507FA2A031DE80BF4CD9A8407FA2A031DE80BF4CD9A6307FA2A031DE80BF4CD9A4207FA2A031DE80BF4CD9A2187D5EDAA43DF6C757B1B56B783B6EC545BE0DBAF95820EB3EBC0EF4CFC866FBF560A3AF01BF89D89DFF0EDD74A41077E03BF33F11BBEFD5A29E8C06FE077267EC3DBE595820EFC067E67E237BC5D5E29E81BA5F1F5262C6F079DD9751E1FA6F895810E53FC40DFAC697AA0AF32D081BE40DFAC5978A0AF32D081BE40DFAC4976A0AF32D081BE40DFAC3974A0AF32D081BE40DFAC2972A0AF32D0374A80B71BDD1D26C0619E0D44C480AFBC560A3ACCA303BFB3F0BB0E5F79AD1474E037F03B13BFE12BAF95820EFC067E67E2377CE5B552D081DFC0EF4CFC86F7C82B051DF80DFCCEC46F788FBC52D0375BC7DE327698C687C940D01999C787C94065A0C35C3ED0376B9A1EE8AB0C74A02FD0376B161EE8AB0C74A02FD0376B921DE8AB0C74A02FD0376B0E1DE8AB0C74A02FD0376B8A1CE8AB0CF4150970F91365BEE37FA38226CCB60EC79CB0048F9EE4BFD90F22092E6B75337344E1980F24A85A7265ABD34833DE2CC9AA47FFBECAB1378CFAB224BB7CFAAD8FBDB485D2A797937D378927AABE8D868D16DB6D4977CF5294D4230A09DDAEB0CF69037A749D5EE063539885CF4840D83DA9F50794A3EFD4F51DC28985A8D743B90BCAEEEA5EC248A040C726C3C580628BCEF8B1D0D3D2674D95EBE39C4716E5EA97C57BCC517A0D15A4F7D5C39F5BCB62F8C1F62662D3EF61CF9C52862C3BE0C3B0E3E4D651BA3510B71BCD861EEFDE3CEF06B6D4C36B1A84D732E2846B12A2313A6C821199DA9E754CCDF002879A77C48A36F19360E0B9F79D3891AD60C7A10F57F78439D80F0F0811F682DE83D89972EEF7342D30A7C4C5C13EF589274E8E29733117BB6CA2C595711DADAEEB6DED418CB53EA326090271F4383A590BAB9A22468FE1539E5243F57B3E0D6C6E53EF475A9353465D6115D499B95E2DB9E66A3C0E08EF7F6D75DB5D5DB4E8FCC164372AE745A9BF164A95AC9B30EC4F170B6E1ED4DB2BCBFD15DE20F448582B32453DDAAD4ED368B56AC814D5E91ACD665A25321E13939F4497460DCDA3BE0AFF1DCDD5FE4160B9140619EF5A543829C816BDD5AD210FBB8249D7B6C9678CA06E728B79797F266B609BA74C5C210D0BF726734706A2C303E451C1466F420E035F8009ED22EA5CBC41DFBA381D915603D8F6197345C95101CD98BD41517ED466A234B1D5F35358626BEBD2BC7BD123B2CE72473445DC5FF5C5FEAA87ED955C246F09DBEF551123C7F64F6DC741966F4BC3902D208FC590D93A80E9786C9B44107EE60A938B5047764FBD606AFB8130BD1E714752066E8863BB784222A9C4BD809937C240E21DCE0837A772732C302527B4B933DA3CE8A80A811FD9C0E398B9F257C059243A96CC59451BEDF9769F05FC8C088F5E6E7CAB3101A296B65DF42C2DEED7F0BE397B99DF8F8C3552D9508353F1DD3A26FAD4718EA2B99A4C3E801CA19C227CDD1B415176172C75603FA7C1C1EA59A502C272528397340EF22E8F2101A84E02B0BA1C85C069DBC0A9DDAD1BAD020227A3DE6C668D9CDA7ABDD3D00B8A9CE400F7D21537D29B207682D82987D8A9BEABD8693971D4889DE4CFC8591C64E2F1E41E7B76307DE9A22F4ABDF5283C4E7A271DE813CF426237F265030FFB432284500CC4E7327A1165D4E469693B7CE144E2DDAE1AA47F1166616F7E344B8F2C1FCEF2F713F287F072BCCFD54B59E6E8FD968C45B58437485A90512BDED9DBA42B12E727364FF113074F23E7963F392479C4B09E844623E7BDB04A5C32089D82F4DCD87E24567C165BA357B63EFFD8331194C5E5E413FE35E50CEC3BAF2E6D11CEF942F48E18C177474468277989AE504F728548DC72CC78A20352248EE2137AEDA57824C7C3C3639B0873119884859E8B1BDBD1C50B3272BE545AC2C787059C7B678CCEFCEF74E68510E69A23BC44CAB0BCE0DCB3C8637AC15723B9C2C1CB2FA82717240F97469D9E9624BBA10FAF1F93D430BD72A139E6AE1F486779ADCB538CEB5FBE66E1DA622F6E2712CB069715A6241E1EF86C756C548CF1BE1836DFE672F3A0482EEFB26ADD4677E92B968B49AA8372EABCF1285C480669B779A0B59764DC5E0ECE6F87484A28C3A678E26F9EFFA28C8D1B47B8AA7680470EF9E95B423EE77DCDB7078F45A5376AEF799F5A06AFA2F1CAAB38E834970FD7AF9C0A3CE3746C27436AE96EC572A0DB3A09F92F17FD5CBC7C5E804983E0AF307D75317C6F4D0DFAFD07DAFBB2B7B7B7AFEBBA027C2D3AB5BACB80A9848571E8225A51452C744A59AAC6E892EE2BA4C6A553226987736BF75FE6A81A05D44DEA242E3D24758A25D1B2A44EBDEA491D70BF4A77BFD649D22CFAD82F9234A2B785FD9D2FCDEB2C2670BA6B27708C8A26708C17D7BF9B63798D71FDCBD72C5CAD04CEE7706DC0DB5F0B00EFD79B5F8C567BBFD3082BBEA30A2B1E5D6C1855403401D184B4825643196A658E5A8AF375E200677D4FE7DDA0A6FCA6CBCD776DB73A4BA7311653FD9D65A9FE0A2D472D34F558A0D40FA77680E4EB95B62755BF383EC3C2D84D9DB8E2079532129515AB45BF5CCFF9932F5E2EC75B2F6D99B572A8DF222542D774E659C167F4EAE7347870B47620FDE93CFC2FF556EB8B70E294F1F42B44AEA3593025CE6767D7D14F4853BDCDB08383CE9756B7BEDF6DAB93A7D2D65AC5D5E8349AEB8476E9CC4B91A15D09CBD9F20E8D9B7A6BADD0B855DDF6DBC68857BCC95BAF972F7E59E02CC920BA2EB56CFEB47F29A75677F6DD9BCD9BB2A82FD5AC8188F77FEEDFEEA3E3C39B7FA2CBAB9BE18F939B4B747B7D737E7986FEFA717238CC4D377368A74D84B45D6FAD25A4A5084155D6E7ADE8AB327CBB126DAEC07AC4933C9897599FEAC8B66C1EDB9B5C53C6BF0BF106DDCEA8DBB2E184ED5A2A19577EC1E44E992BA2CB306DBF07CC5DC6DC5B133B64689B776417B3B655E76DBDA9925195FA0D5BA3DD5DFB5B3BADF65AF15B29F16F95BEE2A10AAC0F35A1F8E223DC3AFC1D7935A1F3FEC5ED0798E0D22AFE1D2155607D600582BF74AF2674DE3F05090209FA0C12D4000952123AEF1FFF13140814E8E32B5013144849E8BC3FFC0B140814E8E32B500B144849E8BC7F7D7395DFCA05D020D0206535A80D1AA42474DE3FFDF9715241DA3BABACBACB17595576311528A172B8D7989683BF8DBB0B9D339AC99B05956B60F803DC2032D944A60E22B31391D1416340633E89C634406376A4310DD018D0984FA1314DD0989D684C1B1C191099CF22322D1099DD64641AFB06880C88CCA71099F6A2C8C0AC17246ACA9AF7325A8DF60E27BE60050008A0DE8115004A42E7FD8B9F1F460841814081DE54A003502025A1F3FEF2D607550255FAF8AAD4055552123AA8923AF502552A59950C1D544949E8A04AEAD40B54A96C55824F1AA9091D54499D7A812A95AD4AF0992335A17F78557A6FDA0F5E770371DC757AAB038BAB60814361FE17680C688C9CD8038D51063AD017E89B8DBE5DA0AF3AD081BE40DF6CE90F1DE8AB0E74A02FD037EB9C0AD05719E8405FA06FD6C90778AF4819E89F7EC6C168B5E1452350C49D2A22FCC90735A17F7871045502557A5395E0CF40A8091D54499D7A812A95AD4AF0A721D4840EAAA44EBD4095CA5625F863116A42075552A75EA04A65AB127CC0464DE8A04AEAD40B54A96C55828FDAA809FDC3ABD2BB53817A13DE3E0275DCF55C202C6E52063A2C6E02FA66A32FFCF90785A0037D81BED9E80B7F584121E8405FA06FD66918A0AF32D081BE40DFACF315405F65A0037D81BE5913FB405F65A06F94006F37BA3B4C80C3EC208888011F975713FA879F1D045502557A4B95EAF0717935A1832AA9532F50A5B255093E2EAF2674502575EA05AA54B62AC1C7E5D5840EAAA44EBD4095CA5625F8C68A9AD04195D4A917A852D9AA04DF585113FA8757A577A702F596B1C3A940585000EA28E70261418132D0613D10D0379B73039FD957083AD017E89B8DBEF0997D85A0037D81BE59A76180BECA4007FA027DB3CE57007D95810EF405FA664DEC037D9581BE22012E7FA2CC77FC6F54D084D9D6E1981396E0D193FC37FB4124C165AD6E668E281CF38104554BAE6C751A69C63B994D782BC7DE30EACB92ECF2E9B73EF6D2164A9F5E4EF6DD249EA8FA361A365A6CB725DD3D4B51528F282474BBC22E7A053DBA4E2FF0B129CCC1672420EC9ED4FA03CAD177EAFA0EE1C442D4EBA1DCA6A17657D712947F77957B353C0C28B6E88C1F0BFD2C7D6E57B93ECE7924D9215FFB7A5BAB7734A3FB710999C5F5CD71DC305418375E3DFCB9B52C861F6C6F2236FD1EF6CC2965C8B2033E0C3B4E6E1DA55B0371BBD16CE8F1EECDF36E604B51BFA641782D234EB80C247230C2261891A9ED59C7D40C2F70A87947AC68133F093939F7BE1327B215EC38F4E1EA9E3007FBE10131927841EF41EC4C39F77B9A169853E2E2609FFAC41327C794B9988B5D36D1E2CAB88E56D785453F0847C167D42441208E1E47276B615553C4E8317CCA536AA87ECFA781CD6DEAFD486B72CAA82BAC823A33D7AB25D75C8DC701E1FDAFAD6EBBAB8B169D3F98EC46E5BC28F5D742A95242260CFBD3C5829B07F5F6CA727F8537087115D68A4C518F76ABD3345AAD1A324575BA46B39956898CC7C4E427D1A55143F3A8AFC27F4773B57F10582E8541C6BB16151E16B2456F199D1AF2B02BA8746D9B7CC6089247A2ABCCCBFB335907DB3C65E212695AB837993B32105D1E208F0A3E7A137218F8024E681951F7E20D7AD7C5E900BB1AC0B6CF982B4A0E7268C6EC0D8AF2A34613A589AD9E9FC2125B5B97E6DD8B2E9175963BA229E21EAB2F76583D6CAFE422794BD87EAF8A1839B67F6A3B0EB27C5B9A866C01792C86CCD6014CC763DB2482F23357185D843AB27CEA0553DB0F84F1F5883B924270431CDBC513128925EE05CCBC110612EF7046B839959B63812939A1CD9DD1E641475508FCC8061EC7CC95BF02CE22D5B1E4CE2AE268CFB7FB2CE06744042472E35B8D0910B5B4EDA2676971BF86F7CDD9CBFC7E64AC91CE862A9CCAEFD621DDA70ED3144D3565F202E418E5E4E9D3DD086AB2BBE0854BF7390D0C96282B15CF9693C9BCA4718C7A790CF9CAC29719FFB81A1C8B26DF4706FA13BBFEDF503DB75072D719D6EAAA0A0477DB0677ED6EDD681510DC19F566336B74D7D6EB9D865E547477F02ABA3B80E80EA2BB1CA3BBC6AEA2BBE5C45123BA933F23677190C9673C591C15AC47E14ED33B19159C781612BBD28E020FFB47F161A9FE8FB1FB3E7F3C19E6F2C79671248EDB4AFCC48EC7C8B9E54F0E494A1F26919638114725DDAED1581694882B96071F492026517FAB857F49279ECAD2C3ED29B6E843BC33662105C36D318450A9B8E17FC9802E7C8422CA7D1916E559328B6785732F5838E0B6457EBC4C7A4705EB590BC6334E5F14FB2B7FC4DA2B13193983D0A3498D49C218DBFCD9A006822F69D4DC3C9C2F28B5D733110CC737E41376378CCEC152037F23B8AE9E7D3FA7035E58E7AEDEC97B3FAD537612298F086E483976C2095E62213EB503240772647BE862D87B3B89F47636A8DBD25530CBF7724960549B0DD085AC705803CEAB444F68B8678C06C15F61507A317C6F6902FAFD07DAFBB2B7B7B72F4CA6B8750A9BB76D512B0BD640C4FBF5E617A3D5DE172E73FEAB01366F928D5EFE3E687F7809FA106253E0A23324FF3B2601B7BD303ADD6428AB77EBAD0ADA51BEBEF0E7B0C4EA0C7B7336FD9DCE3CCE6C12EC6E4D5E45C7BA7FC33EF62A32CCE53D5D9B356E7C561988FA1450AA7CA2BE730F5D0BF5B0823242BCE5160401DA071FA91603B4C1D1DA011A0C580B7C6D35BED45BAD2FADCE414546ADDC82B3F2C5E343C844D1A1D5913640F2759032E2AA5C4C00A2A28F3CD61CD98E73351E604B2E0AD9E95B4A151D608A7B1308822295A77AC1ADCE39AC3A9A0553E22818578109ED5ACF94192D1723B3A39F3075B6CDE07970D0F9D2EAD6F7BBED4F377756450D2A496D5408862AB0444CD92E8B7D4CF9B3F652CD5F8459D89B47941EC982E0E33D6BB5146E5C7C4E63ED16CF4F07C2E5C992E3C3E109FAFDAFA876A159DA93F8AF867EFF0BBA38B9393B39BDBAB9381CA20D46D3FC9B2BF3F0B90504DE6F671825B77A9056D683EA9D8F57253D5336207F9B7CE9BEE4FCF45CE23D3C8AC7EADC37968BC9359E902C1F4FDA49ABEC4690F37D97F4FAF0ECA40C5D56E9FDD1DD50A86F54D49ED557A737666FE81824A40409B9FC792155E416640464646D194922B280983CBA6D4AB0088C6FC89830E299F285B7385140C678E670F9BEA51DBD6CF9C362E9ABB779BDCC193923E28149DD3D61C4D20B894FF9938BB04A3215215A4B3F08637C16BF231EEF72EA8B9DF0FDCB243DF1BC1FD5EF5BADA387F32F634AF9DCEE64C6C3DD345390348C264BB29EC20D2BAE41FFFF01504B0304140002000800C069DB4EA65BAE2587040000B52800000F000000776F72642F7374796C65732E786D6CED59DD72A336147E1586FB2CE0F566BD9EF5EE246EDD64264D334DDA7B1964A346488C24E2A4AFD68B3E525FA112482CBFC68E8993DDC15C201DA4A3A3F37DE71C81FFFBE7DFCF5F1F236C3D40C6112533DB7BE7DA16243E0D1059CFEC44AC4E26F6D72F9F37532E9E30E4961C4DF87433B34321E2A9E3703F8411E0EF680C897CB6A22C024276D9DAD95016C48CFA9073A92CC2CEC8754F9D0820622B8501F57F822B9060C15597DD30DDD5BDF4B6A044706B3305DC476866DFC23585D61F97B61485678497448E9AB1944F1E009ED9AE16A0AAC00731AFCAB860E81E56A584DE304A5755F10320888735B5145366842011D4A8FEDB08BD8916254642288166581818A98F21606A87A94AA36C335D215C562D51136718AD8999B9041C6294EBC480AC55CBD1FE74AA5E8EAB3D75BB8730BE868FA2BA4125BF92CA6BCE8BC11A9E3308EECFA184BFE6C50D0AE8662E716414E7AE30BB4EE298497E28BDD749B49434AC41D3E0989A278C9E3329BA788A4348EA7A62E04B1A4AB1F2D0EF0986DF3CAB24337B3476556799EE229D2879B71290E976F6402DA17515C754C519F748905ACBB8B84A9748C763B812BAC9D03A14450E11213D9F007C9B5B5BDAC41205353EFFE51B89526C6BC0630D781162A716746950CBE9E22996D6C58081350371A84C4B1F5D0633FB26B534C86629E8D2D000510EF4B58A796CC89091688B512909B5205DA46E881F4A4B7CE9D59221F32E43F4CEAC1BB30F4BA50F833F8CD0050A0248B2FE738DA82FABA0B532F61A98641C06BFE56139777BB66154B341921E3249E37B3BD75C4B4AAEFC2D16D51CA472338676254FB4D823C0528D2DD872B71B3BACBB6C6691233B447689338D1B72DD92E9D2D025CE1B7388F1AF20EBD1584EDBE8B8CB76133C0293292549B3C79E3B691AB0A442D0688B863492B7A870CA06394543350D64CBEF224403007597A7BEB66E5114CB9BD7CCC93BF7D8609CCBE380CCEFDFC028D14F15CA993D4E1B32F7995CC94320AB87EEAC98DCA46EEBDA58583547B177BD39F8BD6B36ACE95D319267A3005EBC9CEA3FFB57EDD468528AE0CE187DBD10ACE7E32BC4C5B1226FECAAAB29F2F4964A9BCBEED5AC387EDF95F59A463805550FA593A80F89D0E5D031EBEEE5D2F78D2E1DB5B874B4A5ECB5BB47372ED3535A73623F88248A6AE55D751E618AD5D2CAE61F214B3F7B3B6DB5470DED2A40F3E354A09CF243FD19EA4F67FD29B1C4EFB3F2F879D1D9251936C45A4B9139B98020687BF3E83FC816E96F9720DBC6DAC9BE301596DDCADA431457F1DFF993CCC785BA6C531BAAB5D51B7DEA2AAE8D437A614D731DF54E16948A8135036B9A59336E61CD2F8C267196705EB2AC2FCD0CB3C80E07BA8E3A1F20AEF61A18C8DD1E2B724093E50125E8E70FEADA5E82725A8C5CEF8530FFB00DF32C5DBC1EE667A7EADA17F3DE70A9224E10DE11AF435FAC0E00F4B43B88DBDEA78620FE4E83F8637710BF1EE64310EF0FE8A4F93BC89B3DF51F2B5A7BD5FDD68E86E540792E753EB550E7B847FF1EBECA787B835070E06E517F809B3DB7C5CFC361F9C7ADB35ED3DFC039E8C369F9FB2BB45EF3F7B5D1705CFE91C3B8E56FA6E1BCFCD6C2D8B4F897FF01504B0304140002000800C069DB4E0804E60B730000007F00000012000000776F72642F6E756D626572696E672E786D6C0D8B410EC2201000BF42B85BD08331A4B46F41BA6D49BABB84A5E2DF3CF824BF20C799C9FC3EDF717EE3A15E502431797D1DAC56409197449BD7675D2F0F3D4F637374E2134AB7AA0F24AE79BDD79A9D311277C0200367A0DE562E186AC7B299C665C9852388F4130F73B3F66E3024D2CA4C7F504B0304140002000800C069DB4E1D2B12D367010000B102000011000000776F72642F73657474696E67732E786D6C65924D6EC2301085AF82BC2F81F0D30A115059B141454A2F30D893C48AFF643BA49CAD8B1EA957A8936005959DE77BEF4D6646F9FDFED9EEBFA4985CD13AAE5546E6D31999A0A29A715566A4F1C5CB1BD9EFB6EDC6A1F781B949F02BB7693352796F3649E2688512DC541B54412BB495E04369CBA4D59619AB293A17A25224E96CB64E247045BA968C3B23E076005A9756378AE515189CB49B2B888C844192DE850534C27FC225F7DA44F5358D3A345E1F6FA642053EECF03F8E5754EF8A7D3076446061CFFF06AAA501DFAF6804F7E7F26011EA1039838513D8FAD1960F57083D1448CCC840F98587E4EDA419922035963F5D47726AB5D3859F8648A28B8253ECEF43E23CF3B41F28799C880A9B770DF004C60CDFBD94F38C085E567EDE457DA85818B22F2E657AD7D25E4B07AD2F8052549DFBFE18591AD9836F11D96264CBC896235B45B61AD93AB275C7AA9B412BB8AAC349E2B3E3851642B7C88EA3FE84E241E2BFB7FB03504B0304140002000800C069DB4E6D52DEBF9F050000FD1B000015000000776F72642F7468656D652F7468656D65312E786D6CED594F6FDB3614FF2A84EEAD2C5B729DA06E113B76BB356983C4EBD0232DD3126B4A14483AA96F437B1C30605837EC3260B71D866D015A608765D887C9D661EB807C8551B42C5136D5244D566C587CB045EAF7DEEFFDE17B22E5939F7EB979FB4944C03E621CD3B86D39D76B1640B14F47380EDAD6548CAFB5ACDBB76EC27511A20801098EF93A6C5BA110C9BA6D735F4E437E9D262896F7C6944550C8210BEC118307524944EC7AADD6B42388630BC430426DEBC1788C7D0406A94A2B57DE23F22B163C9DF009DBF315A32EA1B0A38993FEF019EF1206F621695B9267440F06E889B000815CC81B6DABA63E16B06FDDB47329222A8435C1BEFA2C043389D1A4AE045930CC259DBEBB7663B360A8CF195681BD5EAFDB730A8D0A017D5F7AEBAC80DD7ECBE9E45A35D4FC72557BB7E6D5DC25018DA1B122B0D6E974BCB5B240A3107057045AB5A6BB512F0BB88580B7EA4367A3DB6D9605BC42A0B922D0BFB1D6749704142A24389EACC0D3CC1629CA31634AEE1AF12D896FE56BA180D9DA4A9B2B8845D5BA8BE063CAFA12A0B20C058E819825680C7D89EBC268C830540C701D41ED5636E7F3D5B9940E709FE144B4ADF713280BA4C09C1C7D7772F4029C1C1D1E3F7D79FCF4C7E367CF8E9FFE6092BC0BE340977CFDCDA77F7DF511F8F3C5D7AF9F7F5E21C07581DFBEFFF8D79F3FAB400A1DF9EA8BC3DF5F1EBEFAF2933FBE7D6EC26F3038D4F1031C210EEEA303B04BA3D43F03051AB2738A0C42884B2230945013B227C212F2FE0C1223B083CA317CC8645B3022EF4C1F97ECDD0BD9546013F25E189590DB94920E65669FEE293ACDA7691C54F0B3A90EDC8570DF48DF5DCA726F9AC8958D8D4ABB212A99BA4364E261806224407A8F4E1032C93DC2B814DF6DEC33CAE95880471874203607668087C22C751747324133A38D32EBA5086D3F041D4A8C049B68BF0C95150289512922A568DE81530123B3D530223A740B8AD068E8DE8CF9A5C07321931E2042416F8438370A3D60B392C9F7A06C51E615B04D665119CA049E18A15B90521DBA4927DD104689D96E1C873AF83D3E912B16821D2ACC76D072CDA4639910185767FE2146E29CC5FE010E42F36249EF4C99B146102DD7E88C8C218A170F80522B8F70FCA6BE4EB06CEC577D7DA9AF6FC8879DB19E96BB7925F03FDAC337E134DE41699D5CB5F0AB167ED5C2DF50E1FF44E32E7AB5ADEFD6959EA872EB3EC684EC8919415B5C75792E5D1CF5E5A41A28A1FCA89084F272C15702060CAA6BC0A8F8108B702F8489E4711445C033DD010709E5F28862552A57275E2CBD56735E7E4C957028B6E9683EDF289D5F73456A14709DAA91AA382B5DE3C645E99C39F28C7C8E57C1E7BD99CFD6622ACB08C0F47D84D3AC6766721F12344AA33F572D3041BBC81799BE45AE2E3D6F3C84239425CE317BE634CE1AC9D6E981D4F8D61A17E53B4BE67442B78AD0BB8CD4D54E4B9DBD5AB9242E8FC08134D3AB7B16F0A344EAE4693B832488DB962F32874E2DF665B72B56AC53AB76BB4492302E36210FE762EA56FEEE272EECAE7B6EAAEE02869BBAD419C91B2DE7DD93DBCB0944E3B14C7CC54C31CCEED1A9406C2F1C1D802199B25D282D77E74B6A84B97C78D41703268BD3CD565BB9E8B3C5BFFC2E292B0A48921066EDA9A5E77A8E57D7B9116AA4D9675718FF96BE342ED117EFFFEC4BBA7CE526B83152A735B9356010A4EBB46D5126422ADB4D1262BFCFE466429149C3803C06AAFE44D277E2A9B1687FD1AFEC859279770B42B18B03C0B06C71226408ED88CCD353B4398B76989547A629EB2DB9C13C99FF0ED13E2283B4729B69082C10E60D248B85022E27CE36D5D830E8FF9B37446ED586E8941D4341E59E6783E2EAED5E7B0AAC5DD48A733E6DEB156ED7BDB33F6D13799E01E9976CE498F9A4D8FE0EA87AC416FB4DB924AFB5B252CC2787D2EA96EE5FAAEB5D6EAF8AB4B4AA56C1A5EE53B5F837AAE27F0AE1DBC7DF3384DF3B57F4EDD562B6B593901A2DFDB7B698B9F537504B0304140002000800C069DB4E9C07B43CD7000000BE0100000B0000005F72656C732F2E72656C739D914D6E02310C46AF1279CF7840805045604317EC10EA05A2C4331395FC2831D09EAD8B1EA957A85B55155454AABAB4FDF9F945797B795DAE9FC2419DA8549FA28671D382A26893F3B1D770E46EB480F56AB9A7836149D4C1E7AA6425560D0373BE43AC76A0606A9332459974A904C352961EB3B18FA6279CB4ED1CCB2503AE996AEB34ECE7E3CDF47E319B807A78CEF49703A9EBBCA54DB2C740916FDCF99110B2293DB1063CA7E2D07DF51BE182C21B523615FA87D8EF2FC7406C9C61831FE8512EB25DD853BD7013AD9DF4EB67E4DB0DAF7E61F50E504B0304140002000800C069DB4EA2BD515B46010000C7040000130000005B436F6E74656E745F54797065735D2E786D6CB5544B4EC33010BD8AE52D4ADCB2400825ED02D842175CC03893C422FEC89E94F66C2C3812576092942CAAFE106113299EF78D1D7F7D7C66CB8D69D81A42D4CEE67C9ECE3803AB5CA16D95F316CBE4962F17D9CBD6436404B531E735A2BF1322AA1A8C8CA9F3606952BA6024D26BA88497EA4D5620AE67B31BA19C45B09860A7C117D90394B26D903D6E6879B00DD044CEEE0760E79573E97DA395449A8BB52DF65C929D434ACC1E136BEDE315013813072DFAD1518713446FAB3DA2365DB77E9D28CFF4F1822E80AD64C027690820DE5D2844E1546B88949EB63E50CE95A55630F23B351F9C821869574C938E1323B51D4B1F0D625BF30A81A8D32719A5CFA788B86D204E1F61D0BDC01F1089F11F0976CA2733107D159C8FF43B04F87D869FF3DEB11372F710505F52BB065940984FDF7A103E1F00E99680E1F9F714BDCCE829FA6B69F10D504B0304140002000800C069DB4EF98BDB0586010000350700001C000000776F72642F5F72656C732F646F63756D656E742E786D6C2E72656C73BD954D6EC2301085AF1279DF9804A9AA2A020B50D52E52A4C205DC6492588D7F643B08CED6458FD42BD40E50524A5D842296F3C699EFD99E713EDF3F469335AB8315284D054F50140E50003C1339E565821A53DCDCA1C978F40235317685AEA8D481FD84EB0455C6C87B8C755601233A1412B8CD144231626CA84A2C49F6464AC0F160708B55B706FA593378CA136405CAECF20805CB8D847300A22868063391350CB839C1C16D455B90A8124C8230839C92AD1A85929728C01E2BF195ACC4FF5B195EC9CAD06BE53157BD5E4F0524077570B28DA3D016FAD3C3C3F4D8420E2B584B055A8799605873222D2C8A8F6005853ACF0437B036FAC06CE5E94EF692678B0BC9393144833176AA3A60A72E76AA9F7BE98E1DC16D9850DE3D65274FF7B297BCACD86564639BA2D3616DE8DF649ACE2F43399D115A33B02C21DBC481ECB2A9CDA62E3BDF66BD3E166653F7FB066957B16BA98DBD269E1BD6AB05DEB05750D44DF6DEC5B7E43F8D5D7FF67B20BF46419F33064BD744BD1A39D5A55BF1F004E11F3FBFF117504B0304140002000800C069DB4E02A7D890690000006C00000015000000776F72642F6461746153657474696E67732E786D6C0DCBC10D83300C00C05522FF8B8157151118A21344D8D0488D13611765B73E3A525728EFD3FD3EDF6969F9E54E3E34150930743D3896B550923DC0DBB6DB1D9679A2E6295A7CB0D905EAAE24EAA905789A558F487C72AB07AB766BC9A8122B8EFD30628E49C0E1FC07504B0304140002000800C069DB4E1520EB661E0100009503000016000000776F72642F6669656C64436F6E74657874732E786D6CB5934D4EC3301085AF12794F9DA67F216A5A092A41D67001634FA945FC237B1292B3B1E0485C8124A5A24A55EFBAF33CFBBD4FF324FF7C7DAFB78D2AA31A9C9746E7643A8949049A1B21F57B4E2ADCDFA564BB598B26DB4B28C5A3D1080DFAA873699F89262707449B512AA086C63AF07EC28DA25E334B93789A50C5A426170951374BD101497FC2D6424E9C31388CDE548E77C2CEF04A81C668C79091885E4D49CE524AE98F2996B9CE5B1C21D7BDB391B7405083544B2FDF4A28B4806ECD78D09CF97C665A947012647F5BE827672A7BDAE61F9C84C0F333B075C682C3F6CF8F879C3C542DB8974A29E6DA57C93F00FD287D164A5F842B9987BCCB1B56B2088157E14AFAD78EF18B2296A1CC345CC42AE4BDBF6111E900A6E39FB5F905504B0304140002000800C069DB4E88096F80B6000000070100001D000000776F72642F736E61704D61696C4D657267654F7074696F6E732E786D6C758F3D0EC2300C46AF126587B49D50D5C0D2850190E809A2C42D91F253396E95BB317024AE4040828DD1EF7B9F653FEF8FEE90BD632B60B231485E6F2BCE20E8686C98245F68DCECF861DF99DCA6A0E693B2EE0438C165A6E22756CA21B5264B7E239A5B210CAC90678494B63A7AF12E89A6AA1BE1950DFCB3C82852435C50C359796085ACCA49DE47BD7808C4FA9273263EAE5E100BBB828E688EC140FEF9D5D719AD23C081B09CFC4BBF618A486F5E26F1E789FD0B504B0304140002000800C069DB4E879864F461000000660000000F000000776F72642F7468656D65732E786D6C0DCA410E40301000C0AF347B67719246798BE8A2896E1B5B4DFFE6E049BEC09CE7BD9F612AFE50994E71810DB475038A7809D6F166E04A6BD5C3340EB6E8B49327517F67D1B618D8538A1AD152A6124F12A997E051788ED8356D877E760C0AC70F504B0304140002000800C069DB4E219AFB35730000007F0000001A000000776F72642F5F72656C732F7468656D65732E786D6C2E72656C737BBF7BBF8D7D456E8E42596A5171667E9EAD92A19E8192426A5E727E4A665EBAAD5269499AAE8592BD9D4D506A4E6209504571466641B102504B5EB1AD524649498195BE7E7172466A6E62B15E7E416A1E50262DBF2837B104C82D4AD72F484CCE4E4C4FD537323030D32F4236434941DF0E00504B01021400140002000800C069DB4EE278490A61010000B0020000110000000000000000000000000000000000646F6350726F70732F636F72652E786D6C504B01021400140002000800C069DB4EB1BE4AF8D5000000FE0000001000000000000000000000000000900100006D656469612F696D616765312E706E67504B01021400140002000800C069DB4EB1BE4AF8D5000000FE0000001000000000000000000000000000930200006D656469612F696D616765322E706E67504B01021400140002000800C069DB4EB1BE4AF8D5000000FE0000001000000000000000000000000000960300006D656469612F696D616765332E706E67504B01021400140002000800C069DB4EBC4EE87C14010000A7020000100000000000000000000000000099040000776F72642F686561646572312E786D6C504B01021400140002000800C069DB4E36B0EC20A71A00008C7802001100000000000000000000000000DB050000776F72642F646F63756D656E742E786D6C504B01021400140002000800C069DB4EA65BAE2587040000B52800000F00000000000000000000000000B1200000776F72642F7374796C65732E786D6C504B01021400140002000800C069DB4E0804E60B730000007F000000120000000000000000000000000065250000776F72642F6E756D626572696E672E786D6C504B01021400140002000800C069DB4E1D2B12D367010000B1020000110000000000000000000000000008260000776F72642F73657474696E67732E786D6C504B01021400140002000800C069DB4E6D52DEBF9F050000FD1B000015000000000000000000000000009E270000776F72642F7468656D652F7468656D65312E786D6C504B01021400140002000800C069DB4E9C07B43CD7000000BE0100000B00000000000000000000000000702D00005F72656C732F2E72656C73504B01021400140002000800C069DB4EA2BD515B46010000C70400001300000000000000000000000000702E00005B436F6E74656E745F54797065735D2E786D6C504B01021400140002000800C069DB4EF98BDB0586010000350700001C00000000000000000000000000E72F0000776F72642F5F72656C732F646F63756D656E742E786D6C2E72656C73504B01021400140002000800C069DB4E02A7D890690000006C0000001500000000000000000000000000A7310000776F72642F6461746153657474696E67732E786D6C504B01021400140002000800C069DB4E1520EB661E01000095030000160000000000000000000000000043320000776F72642F6669656C64436F6E74657874732E786D6C504B01021400140002000800C069DB4E88096F80B6000000070100001D0000000000000000000000000095330000776F72642F736E61704D61696C4D657267654F7074696F6E732E786D6C504B01021400140002000800C069DB4E879864F461000000660000000F0000000000000000000000000086340000776F72642F7468656D65732E786D6C504B01021400140002000800C069DB4E219AFB35730000007F0000001A0000000000000000000000000014350000776F72642F5F72656C732F7468656D65732E786D6C2E72656C73504B0506000000001200120090040000BF3500000000')

WHERE template_id = 'Agtech Advanced Shipment Notice Std(Eng)'

   AND program_code = 'ASMBV-BSD'

   AND language_code = 'EN'

;

but I get this error: SQL Error: ORA-01704: string literal too long

Any assistance would be appreciated
Comments
Post Details
Added on Jun 27 2019
7 comments
17,537 views