I have a table which contains BLOB column as below and I want to insert BLOB data.Please helpe me.
Getting string is too long , any others options please.
using Oracle 12c R2
CREATE TABLE Confg_Big_Data
(
Big_Data_id NUMBER(10, 0),
Big_Data_Type VARCHAR2(28),
Hash_Id VARCHAR2(4000),
Blob_Data BLOB,
Unit_Id NUMBER(10, 0),
Grp_Def_Id NUMBER(10, 0),
App_Grp_Rls_Id NUMBER(10, 0),
CONSTRAINT Pk_Confg_Big_Data PRIMARY KEY (Big_Data_id) ENABLE,
CONSTRAINT Fk01_Confg_Big_Data FOREIGN KEY (Grp_Def_Id) REFERENCES Confg_Grp_Def(Grp_Def_Id) ENABLE,
CONSTRAINT Fk02_Confg_Big_Data FOREIGN KEY (App_Grp_Rls_Id) REFERENCES Confg_App_Grp_Rls(App_Grp_Rls_Id) ENABLE
)
DECLARE
V_Blob_Data1 VARCHAR2(4000) := 'PCFET0NUWVBFIGh0bWw+CjxodG1sIHhtbG5zPSIiaHR0cDovL3d3dy53My5vcmcvMTk5OS94aHRtbCIiPgo8aGVhZD4KICAgIDxtZXRhIGNoYXJzZXQ9IiJ1dGYtOCIiPgogICAgPCEtLSB1dGYtOCB3b3JrcyBmb3IgbW9zdCBjYXNlcyAtLT4KICAgIDxtZXRhIG5hbWU9IiJ2aWV3cG9ydCIiIGNvbnRlbnQ9IiJ3aWR0aD1kZXZpY2Utd2lkdGgiIj4KICAgIDwhLS0gRm9yY2luZyBpbml0aWFsLXNjYWxlIHNob3VsZG4mIzM5O3QgYmUgbmVjZXNzYXJ5IC0tPgogICAgPG1ldGEgaHR0cC1lcXVpdj0iIlgtVUEtQ29tcGF0aWJsZSIiIGNvbnRlbnQ9IiJJRT1lZGdlIiI+CiAgICA8IS0tIFVzZSB0aGUgbGF0ZXN0IChlZGdlKSB2ZXJzaW9uIG9mIElFIHJlbmRlcmluZyBlbmdpbmUgLS0+CiAgICA8bWV0YSBuYW1lPSIieC1hcHBsZS1kaXNhYmxlLW1lc3NhZ2UtcmVmb3JtYXR0aW5nIiI+CiAgICA8IS0tIERpc2FibGUgYXV0by1zY2FsZSBpbiBpT1MgMTAgTWFpbCBlbnRpcmVseSAtLT4KICAgIDx0aXRsZT5CYW5rbmFtZTwvdGl0bGU+CiAgICA8IS0tIFRoZSB0aXRsZSB0YWcgc2hvd3MgaW4gZW1haWwgbm90aWZpY2F0aW9ucywgbGlrZSBBbmRyb2lkIDQuNC4gLS0+CjwvaGVhZD4KPGJvZHkgd2lkdGg9IiIxMDAlIiIgYmdjb2xvcj0iImdyYXkiIiBzdHlsZT0iIndpZHRoOjEwMCU7IGJhY2tncm91bmQ6d2hpdGU7IG1hcmdpbjogMCAhaW1wb3J0YW50OyBwYWRkaW5nOjAgIWltcG9ydGFudDsgbXNvLWxpbmUtaGVpZ2h0LXJ1bGU6IGV4YWN0bHk7IiI+CiAgICA8Y2VudGVyIHN0eWxlPSIid2lkdGg6IDEwMCU7IGJhY2tncm91bmQ6IHdoaXRlOyBtYXJnaW46MDsgcGFkZGluZzowOyIiPgoKICAgICAgICA8IS0tIFZpc3VhbGx5IEhpZGRlbiBQcmVoZWFkZXIgVGV4dCA6IEJFR0lOIC0tPg';
V_Blob_Data2 VARCHAR2(4000) :='ogICAgICAgIDxkaXYgc3R5bGU9IiJkaXNwbGF5Om5vbmU7Zm9udC1zaXplOjFweDtsaW5lLWhlaWdodDoxcHg7bWF4LWhlaWdodDowcHg7bWF4LXdpZHRoOjBweDtvcGFjaXR5OjA7b3ZlcmZsb3c6aGlkZGVuO21zby1oaWRlOmFsbDtmb250LWZhbWlseTogc2Fucy1zZXJpZjsiIj4KICAgICAgICAgICAgQmFua25hbWUKICAgICAgICA8L2Rpdj4KICAgICAgICA8IS0tIFZpc3VhbGx5IEhpZGRlbiBQcmVoZWFkZXIgVGV4dCA6IEVORCAtLT4KCiAgICAgICAgPCEtLSAgICAKICAgICAgICAgICAgU2V0IHRoZSBlbWFpbCB3aWR0aC4gRGVmaW5lZCBpbiB0d28gcGxhY2VzOgogICAgICAgICAgICAxLiBtYXgtd2lkdGggZm9yIGFsbCBjbGllbnRzIGV4Y2VwdCBEZXNrdG9wIFdpbmRvd3MgT3V0bG9vaywgYWxsb3dpbmcgdGhlIGVtYWlsIHRvIHNxdWlzaCBvbiBuYXJyb3cgYnV0IG5ldmVyIGdvIHdpZGVyIHRoYW4gNjAwcHguCiAgICAgICAgICAgIDIuIE1TTyB0YWdzIGZvciBEZXNrdG9wIFdpbmRvd3MgT3V0bG9vayBlbmZvcmNlIGEgNjAwcHggd2lkdGguCiAgICAgICAgLS0+CiAgICAgICAgPGRpdiBzdHlsZT0iIndpZHRoOiAxMDAlOyBtYXgtd2lkdGg6NjAwcHg7IG1hcmdpbjogMDsgcGFkZGluZzowOyB0ZXh0LWFsaWduOmxlZnQiIj4KCgogICAgICAgICAgICA8IS0tIEVtYWlsIEhlYWRlciA6IEJFR0lOIC0tPgoKICAgICAgICAgICAgPCEtLSBFbWFpbCBIZWFkZXIgOiBFTkQgLS0+CgogICAgICAgICAgICA8IS0tIEVtYWlsIEJvZHkgOiBCRUdJTiAtLT4KICAgICAgICAgICAgPGJyPgogICAgICAgICAgICA8dGFibGUgcm9sZT0iInByZXNlbnRhdGlvbiIiIGNlbGxzcGFjaW5nPSIiMCIiIGNlbGxwYWRkaW5nPSIiMCIiIGJvcmRlcj0iIjAiIiBhbGlnbj0iImNlbnRlciIiIHdp';
V_Blob_Data3 VARCHAR2(4000) :='ZHRoPSIiNjAwIiIgc3R5bGU9IiJtYXgtd2lkdGg6IDYwMHB4OyB3aWR0aDo2MDBweDsgcGFkZGluZzowcHg7IGJhY2tncm91bmQ6d2hpdGU7ICIiPgogICAgICAgICAgICAgICAgPHRyPgogICAgICAgICAgICAgICAgICAgIDx0ZCBzdHlsZT0iInBhZGRpbmc6MTVweDsiIj4KICAgICAgICAgICAgICAgICAgICAgICAgPGltZyBzcmM9IiJ7MH0iIgogICAgICAgICAgICAgICAgICAgICAgICB3aWR0aD0iIjIwMCIiIGhlaWdodD0iImF1dG8iIiBhbHQ9IiJCYW5rTmFtZSIiIGJvcmRlcj0iIjAiIiBhbGlnbj0iImNlbnRlciIiIHN0eWxlPSIid2lkdGg6NjBweDsgbWF4LXdpZHRoOjYwcHg7IGhlaWdodDogYXV0bzsgZm9udC1mYW1pbHk6IHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMzZweDsgbGluZS1oZWlnaHQ6IDQ4cHg7IGNvbG9yOiAjNTU1NTU1OyBtYXJnaW46MHB4OyIiPgogICAgICAgICAgICAgICAgICAgIDwvdGQ+CiAgICAgICAgICAgICAgICA8L3RyPgoKICAgICAgICAgICAgICAgIDwhLS0gSGVybyBJbWFnZSwgRmx1c2ggOiBFTkQgLS0+CgogICAgICAgICAgICAgICAgIDwhLS0gRW1haWwgQm9keTogQkVHSU4gLS0+CiAgICAgICAgICAgICAgICA8dHIgPgogICAgICAgICAgICAgICAgICAgIDx0ZCBzdHlsZT0iIiIiIGJnY29sb3I9IiIjZjZmNmY2IiI+CiAgICAgICAgICAgICAgICAgICAgICAgIDx0YWJsZSBzdHlsZT0iImJvcmRlci1sZWZ0OjRweCBzb2xpZCAjMEU4NTdEOyBwYWRkaW5nOjQwcHg7IiIgcm9sZT0iInByZXNlbnRhdGlvbiIiIGNlbGxzcGFjaW5nPSIiMCIiIGNlbGxwYWRkaW5nPSIiMCIiIGJvcmRlcj0iIjAiIiB3aWR0aD0iIjEwMCUiIiA+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8IS0tIGNvcHkgc2VjdGlvbiA6IFNUQVJUIC0tPiAKICAgIC';
V_Blob_Data4 VARCHAR2(4000):='AgICAgICAgICAgICAgICAgICAgICAgIDx0cj4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8dGQgc3R5bGU9IiJwYWRkaW5nLWJvdHRvbTogNDBweDsgZm9udC1mYW1pbHk6IHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMTVweDsgbGluZS1oZWlnaHQ6IDIwcHg7IGNvbG9yOiAjNTU1NTU1OyIiPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBEZWFyIHsxfSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPCEtLSBQYXJhZ3JhZ2ggc2VwYXJhdGlvbiA6IEJFR0lOIC0tPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8YnI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxicj4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPCEtLSBQYXJhZ3JhZ2ggc2VwYXJhdGlvbiA6IEVORCAtLT4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBXZSBhcmUgc29ycnkgYnV0IHdlIGFyZSB1bmFibGUgdG8gYWNjb21tb2RhdGUgeW91ciByZXF1ZXN0IHRvIG9wZW4gYW4gYWNjb3VudCB3aXRoIG91ciBpbnN0aXR1dGlvbiBhdCB0aGlzIHRpbWUuIE91ciBkZWNpc2lvbiB3YXMgYmFzZWQgb24gaW4gd2hvbGUgb3IgaW4gcGFydCBvbiBpbmZvcm1hdGlvbiBvYnRhaW5lZCBpbiBhIHJlcG9ydCBmcm9tIHRoZSBjb25zdW1lciByZXBvcnRpbmcgYWdlbmN5IGxpc3RlZCBiZWxvdy4gWW91IGhhdmUgYSByaWdodCB1bmRlciB0aGUgRmFpciBDcmVkaXQgUmVwb3J0aW5nIEFjdCB0byBrbm93IHRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4geW91ciBmaWxlIGF0IHRoZSBjb25zdW1lciByZXBvcnRpbmcgYWdlbmN5LiBUaGUgcmVwb3J0aW5nIGFnZW5jeSBwbGF5ZWQgbm8gcGFydCBpb';
V_Blob_Data5 VARCHAR2(4000):='iBvdXIgZGVjaXNpb24gYW5kIGlzIHVuYWJsZSB0byBwcm92aWRlIHNwZWNpZmljIHJlYXNvbnMgd2h5IHdlIGhhdmUgYSBkZW5pZWQgeW91ciByZXF1ZXN0IHRvIG9wZW4gYW4gYWNjb3VudCB3aXRoIG91ciBpbnN0aXR1dGlvbi4gWW91IGFsc28gaGF2ZSBhIHJpZ2h0IHRvIGEgZnJlZSBjb3B5IG9mIHlvdXIgcmVwb3J0IGZyb20gdGhlIHJlcG9ydGluZyBhZ2VuY3ksIGlmIHlvdSByZXF1ZXN0IGl0IGluIG5vIGxhdGVyIHRoYW4gNjAgZGF5cyBhZnRlciB5b3UgcmVjZWl2ZSB0aGlzIG5vdGljZS4gSW4gYWRkaXRpb24sIGlmIHlvdSBmaW5kIGFueSBvZiB0aGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoZSByZXBvcnQgeW91IHJlY2VpdmUgdG8gYmUgaW5hY2N1cmF0ZSBvciBpbmNvbXBsZXRlLCB5b3UgaGF2ZSB0aGUgcmlnaHQgdG8gZGlzcHV0ZSB0aGUgbWF0dGVyIHdpdGggdGhlIHJlcG9ydGluZyBhZ2VuY3kuCgkJCQkJCQkJICAgPGJyPgoJCQkJCQkJCSAgIDxicj4KCQkJCQkJCQkgICAgQ2hleCBTeXN0ZW0sIEluYyA8YnI+CgkJCQkJCQkJCUF0dG4uIENvbnN1bWVyIFJlbGF0aW9ucyA8YnI+CgkJCQkJCQkJCTc4MDUgSHVkc29uIFJvYWQsIFN1aXRlIDEwMCA8YnI+CgkJCQkJCQkJCVdvb2RidXJ5LCBNTiA1NTEyNSA8YnI+CgkJCQkJCQkJCTxicj4KCQkJCQkJCQkJVGVsZXBob25lOiA4MDAtNDI4LTk2MjMgPGJyPgoJCQkJCQkJCQlGYXg6IDYwMi02NTktMjE5NyA8YnI+CgkJCQkJCQkJCVdlYjogd3d3LmNoZXhzeXN0ZW1zLmNvbSA8YnI+CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPCEtLSBQYXJhZ3JhZ2ggc2VwYXJhdGlvbiA6IEJFR0lOIC0tPiAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPGJyPgoJCQkJCQkJCQk8';
V_Blob_Data6 VARCHAR2(4000):='YnI+CgkJCQkJCQkJCVdlIGFsc28gb2J0YWluZWQgeW91ciBjcmVkaXQgc2NvcmUgZnJvbSB0aGlzIGNvbnN1bWVyIHJlcG9ydGluZyBhZ2VuY3kgYW5kIHVzZSBpdCBpbiBtYWtpbmcgb3VyIGNyZWRpdCBkZWNpc2lvbi4gWW91ciBjcmVkaXQgc2NvcmUgaXMgYSBudW1iZXIgdGhhdCByZWZsZWN0cyB0aGUgaW5mb3JtYXRpb24gaW4geW91ciBjb25zdW1lciByZXBvcnQuIFlvdXIgY3JlZGl0IHNjb3JlIGNhbiBjaGFuZ2UsIGRlcGVuZGluZyBvbiBob3cgdGhlIGluZm9ybWF0aW9uIGluIHlvdXIgY29uc3VtZXIgcmVwb3J0IGNoYW5nZXMuCgkJCQkJCQkJCTxicj4KCQkJCQkJCQkJPGJyPgoJCQkJCQkJCQlDcmVkaXQgU2NvcmU6IHszfSBDcmVkaXQgU2NvcmUgRGF0ZTogezR9CgkJCQkJCQkJCTxicj4KCQkJCQkJCQkJPGJyPgoJCQkJCQkJCQlTY29yZXMgUmFuZ2UgZnJvbSBhIGxvdyBvZiAxMDAgdG8gYSBoaWdoIG9mIDg5OQoJCQkJCQkJCQk8YnI+CgkJCQkJCQkJCTxicj4KCQkJCQkJCQkJS2V5IEZhY3RvcnMgdGhhdCBhZHZlcnNlbHkgYWZmZWN0ZWQgeW91ciBDcmVkaXQgU2NvcmU8YnI+PGJyPgoKCQkJCQkJCQkJezV9PGJyPgoJCQkJCQkJCQl7Nn08YnI+CgkJCQkJCQkJCXs3fTxicj4KCQkJCQkJCQkJezh9PGJyPgoJCQkJCQkJCQl7OX08YnI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxicj4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPCEtLSBQYXJhZ3JhZ2ggc2VwYXJhdGlvbiA6IEVORCAtLT4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJZiB5b3UgaGF2ZSBhbnkgcXVlc3Rpb25zIHJlZ2FyZGluZyB5b3VyIGNyZWRpdCBzY29yZSwgeW91IHNob3VsZCBjb250YWN0IHRoZSBjb25zdW1lciByZXBvcnRpbmcg';
V_Blob_Data7 VARCHAR2(4000):='YWdlbmN5IHVzZWQgaW4gdGhlIGNvbnRhY3QgaW5mb3JtYXRpb24gYWJvdmUuIElmIHlvdSBoYXZlIGFueSBvdGhlciBxdWVzdGlvbnMgcmVnYXJkaW5nIHRoaXMgbm90aWNlLCB5b3Ugc2hvdWxkIGNvbnRhY3Q6IAoJCQkJCQkJCSAgIDxicj48YnI+CgkJCQkJCQkJICAgezEwfQoJCQkJCQkJCSAgIDxicj4KCQkJCQkJCQkgICA8YnI+ezExfQoJCQkJCQkJCSAgIDxicj4KCQkJCQkJCQkgICA8YnI+ezEyfQoKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC90ZD4KICAgICAgICAgICAgICAgICAgICAgICAgICAgIDwvdHI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8IS0tIGNvcHkgc2VjdGlvbiA6IEVORCAtLT4KCiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8IS0tIHNpZ25hdHVyZSBzZWN0aW9uIDogU1RBUlQgLS0+IAogICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRyPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx0ZCBzdHlsZT0iInBhZGRpbmc6MDsgZm9udC1mYW1pbHk6IHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMTVweDsgbGluZS1oZWlnaHQ6IDIwcHg7IGNvbG9yOiAjNTU1NTU1OyIiPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBTaW5jZXJlbHksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxicj4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgezEzfQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDwvdGQ+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgPCEtLSBzaWduYXR1cmUgc2VjdGlvbiA6IEVORCAtLT4gCiAgICAgICAgICAgICAgICAgICAgICAgIDwvdGFibGU+CiAgICAgICAgICAgI';
V_Blob_Data8 VARCHAR2(4000):='CAgICAgICAgPC90ZD4KICAgICAgICAgICAgICAgIDwvdHI+CiAgICAgICAgICAgIDwvdGFibGU+CiAgICAgICAgICAgIDwhLS0gRW1haWwgQm9keSA6IEVORCAtLT4KCiAgICAgICAgICAgIDwhLS0gRW1haWwgRm9vdGVyIDogQkVHSU4gLS0+CiAgICAgICAgICAgIDx0YWJsZSByb2xlPSIicHJlc2VudGF0aW9uIiIgY2VsbHNwYWNpbmc9IiIwIiIgY2VsbHBhZGRpbmc9IiIwIiIgYm9yZGVyPSIiMCIiIGFsaWduPSIiY2VudGVyIiIgd2lkdGg9IiIxMDAlIiIgc3R5bGU9IiJtYXgtd2lkdGg6IDYwMHB4OyIiPgogICAgICAgICAgICAgICAgPHRyPgogICAgICAgICAgICAgICAgICAgIDx0ZCBzdHlsZT0iInBhZGRpbmc6IDE1cHggMTVweCA0MHB4IDE1cHg7IHdpZHRoOiAxMDAlO2ZvbnQtc2l6ZTogMTJweDsgZm9udC1mYW1pbHk6IHNhbnMtc2VyaWY7IGxpbmUtaGVpZ2h0OjE4cHg7IHRleHQtYWxpZ246IGxlZnQ7IGNvbG9yOiAjYmJiOyIiPgogICAgICAgICAgICAgICAgICAgICAgICBBbGwgcHJvZHVjdHMgYW5kIHNlcnZpY2VzIGFyZSBzdWJqZWN0IHRvIGFwcHJvdmFsLCBpbmNsdWRpbmcgY3JlZGl0IGFwcHJvdmFsLiBUaGlzIGVtYWlsIGF1dG9tYXRpY2FsbHkgZ2VuZXJhdGVkOyBwbGVhc2UgZG8gbm90IHJlcGx5IGRpcmVjdGx5LgogICAgICAgICAgICAgICAgICAgIDwvdGQ+CiAgICAgICAgICAgICAgICA8L3RyPgogICAgICAgICAgICA8L3RhYmxlPgogICAgICAgICAgICA8IS0tIEVtYWlsIEZvb3RlciA6IEVORCAtLT4KCiAgICAgICAgICAgIDwhLS1baWYgbXNvXT4KICAgICAgICAgICAgPC90ZD4KICAgICAgICAgICAgPC90cj4KICAgICAgICAgICAgPC90YWJsZT4KICAgICAgICAgICAgPCFbZW5kaWZdLS0+CiAgICAgICAgPC9kaXY+CiAgICA8L2NlbnRlcj4KPC9ib2R5Pgo8L2h0bWw+Cg==';
BEGIN
--INSERT INTO Confg_Big_Data(Big_Data_Id,Big_Data_Type,Hash_Id,Blob_Data,Unit_Id,Grp_Def_Id)
--VALUES(1, 'TEXT', NULL,EMPTY_BLOB(), 1, 42);
-- UPDATE Confg_Big_Data
set Blob_Data = utl_raw.cast_to_raw(V_Blob_Data1)||utl_raw.cast_to_raw(V_Blob_Data2)||utl_raw.cast_to_raw(V_Blob_Data3)||utl_raw.cast_to_raw(V_Blob_Data4)||utl_raw.cast_to_raw(V_Blob_Data5)||utl_raw.cast_to_raw(V_Blob_Data6)||utl_raw.cast_to_raw(V_Blob_Data7)||utl_raw.cast_to_raw(V_Blob_Data8)
WHERE Big_Data_Id = 1;
WHERE Big_Data_Id = 1;
END;