Hi Team,
We need the signature to be included in the report.
Issue Description:
We attempted to convert CLOB to a BLOB in the backend. However, during the conversion from CLOB to BLOB, we encountered the following error.
Note: The variable picture_data was tested using both Long Text and Binary data types, but the issue persists.
Note: This implementation is currently working in the SQL developer Studio.
Error:

Code:
SELECT question, answer, survey_id, date_created, CASE WHEN picture_data IS NOT NULL THEN
JT_TASK_SIGNATURE_API.Clob_Base64_Blob(REPLACE(picture_data,'data:image/png;base64,',''))
ELSE NULL END AS picture_data FROM Jt_Task_Survey_Answers WHERE task_seq = 113;
Thanks,
Venkat