Hello everybody,
it's been several days that I'm trying to solve this task. I have a huge pdf file into a BLOB column (more than 40000 chars) and I have to retrieve it and put it into a JSON_OBJECT_T as something like that:
{
"fileContent": "JVBERi0xLjQNCjUgMCBvYmoNCjw8DQovVHlwZSAvWE9iamVjdA0KL1N1YnR5cGUgL0ltYWdlDQovRmlsdGVyIC9GbGF0ZURlY29kZQ0KL0xlbmd0aCA5NTM4DQovV2lkdGggMjY1DQovSGVpZ2h0IDExNg0KL0JpdHNQZXJDb21wb25lbnQgOA0KL0NvbG9yU3BhY2UgL0RldmljZVJHQg0KPj4NCnN0cmVhbQ0KeJztfQdYVEn2LzM7/w2zad7b93Zmdv67O/NmHRNgDigmREUBMSAZJCNZcs5BARFBJCMqgoAiimBGUZKgIDnnnEFy7v/pe+nrpRu1L9068r36ffXx3W761qk6Vb+qc86tW0WjISAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHxqTExMVte2VNe1sp8amztnZmaoCoJbmlo6KQlq7+pjM/OxsYnqWgo519a3TUxOUa0CO+h/M8R+MXp6B/C7RkbGKGkG0sDgCBeLPTg4QkmB9Nbp6KUkYmRsnGod6xo7FtDTuIWaulaen47yLJVhP63ebwzVpCpofGJyo7gZJUF8oib97HWA10XVPP9Pkv2c/8KvWNXYTl1bH8DL4prVVOqoZn4BvzG/pPbrlfIUlPOLtLV3NBdLHnsnjec/UpRaR1rbk5KItLyK3yyXpSTi3zt0oNtwsZqUUFPfRi8GvyL7ac1B8wVS44gVJUE8vPKeIbfZyfx1cQ0PqJ3tnP+6XrW6sYO6tt6J6Z..."
}
Thus, the first step I need to do is to retrieve the BLOB and encode it properly in base64 but I have to do it with chunks because, as I said above, the BLOB is very large.
Then, after encoding the binary pdf in base64, I have to put in the json above.
Can anyone please help me with that?
