I have an unknown length of characters to store. Hence, I opted to use CLOB in my PL/SQL.
My statements are quite simple:
...... msg := msg || 'more text';
I got a ORA-6502 numeric value error - host bind array too small. I checked the size of the variable at the time was only about 200 bytes.
1) what am I doing wrong?
2) Is there a solution without involving a CAST statement?
3) does CLOB take up unused space when the actual size of the content is small?
any leads or help is appreciated. Thanks in advance.