When extracting details from BLOB column using Pega function pr_read_from_stream receiving error ORA-06502: PL/SQL: numeric or value error: character string buffer too small and ORA-06512: at “.PR_READ_FROM_STREAM”, line 39.
Does anyone have solution for this. I need solution only to extract the value in reports and no changes to database.
Hello @SatishKumarG16903123 , can you please give some more clarity of what you are trying to do? If you share a screen shot with full query and the error message that will help understand the issue better. - I assume if the value that you retrieve from BLOB is not able to assign to the variable to hold (if you declared a variable with small size compared to the actual size stored inside BLOB.
Hi @SatishKumarG16903123 : Can we know if you are facing this from application or when you use the function directly in DB?
Can you also try to add filters to your SQL / RD to limit the number of rows retrieved to see if it works?
Thanks.