How, when making a java (groovy) program, to pass a parameter to plsql not as a string, but as a byte array?

Question

Oracle

Hi all.
I am writing a groovy program for parsing an excel file, after which I make one variable, into which I pass all the parsed values ​​of two columns, separating the columns from each other through ; and lines \r\n
Total 11k lines, variable of type String, but when passed to the plsql code snippet, an error occurs:
because: ORA-06550: Line 18, column 34:
PLS-00172: string literal too long

As I understand it, you need transfer not as a string, but as a byte array. How to do it?
Always passed values ​​through '${NAME}'

Example, specifically in this problem: P_Clob := etran.blob_to_clob('${Plob}');

Answer 1

tr1ck1 , the error message, in Russian, does not tell you anything at all? not even a bit?

PLS-00172: string literal too long

Probably you are trying to insert into one single record of type varchar, string where you stuffed 11k lines, it probably does not fit stupidly?
Try changing the column type to text, but think about it, do you really need a database here?