ORA -06502 : PL/SQL: numeric or value error: Bulk Bind: Truncated

 Hi All,

I am encountering an error ORA - 06502 : PL/ SQL: numeric or value error: Bulk Bind: Truncated.

Below is the code:

In the cursor the column afn_data is a CLOB datatype which contains XMLELEMENTS and encoded jpeg value whose length is more than 22000 bytes. The below code works fine if i run it as a PL/SQL anonymous block, but if I include this in my DB Package it gives out the above error message. it's quite frustrating thou to see it works in an anonymous block and not in the DB package.

Does anyone has knowledge how to get rid of this error and get it working. Thanks in advance