Pl/SQL BLOB used in IN/OUT parameters and how to see o/p of BLOB returned in PL/SQL object and h

iam not able to get a BLOB as o/p parameter used in a pl/sql collection object, as well as input it via POSTMAN example:

GET: https://data-crboips-dit.fmrco.com/compliance/uda/get_all_attachment_by_escid/v1?PV_ESCALATION_ID=“3143”

pl/sql type and object:


CREATE OR REPLACE
TYPE COMPLIANCE_EUD.CR_IB_EDIT_ESC_T
FORCE AS OBJECT
( ESCALATION_FILE_ID NUMBER,
ESCALATION_ID NUMBER,
FILE_NAME VARCHAR2(300 CHAR),
FILE_LOCATION_DESC VARCHAR2(4000 CHAR),
ACTIVE_IND VARCHAR2(1 CHAR),
FILE_CONTENT_BLOB BLOB
)
/

CREATE OR REPLACE
TYPE COMPLIANCE_EUD.CR_IB_EDIT_ESC_COL_T FORCE
AS TABLE OF CR_IB_EDIT_ESC_T
/

pl/sql procedure:


procedure prc_get_all_attachment_by_escid (
pv_escalation_id in number,
pv_cr_ib_edit_esc_col_t out cr_ib_edit_esc_col_t)
as
gc_pkg_name constant varchar2 (100) := ‘CR_IB_ESCALATION_LOAD_PKG’;
gc_mod_name constant varchar2 (10) := ‘IB’;
lv_proc_err_hdr constant varchar2 (100)
:= gc_pkg_name || '.prc_get_all_attachment_by_escid: ’ ;
lv_checkpoint varchar2 (200);
lv_tab varchar2 (30) := ‘CR_IB_ESCALATION_FILE’;
lv_count number;
lv_encrypted_blob blob;
lv_file_id number;
begin
select compliance_eud.cr_ib_edit_esc_t (escalation_file_id,
escalation_id,
file_name,
file_location_desc,
active_ind,
file_content_blob)
bulk collect into pv_cr_ib_edit_esc_col_t
from (select escalation_file_id,
escalation_id,
file_name,
file_location_desc,
active_ind,
compliance_eud.cr_ib_blob_encrypt_decrypt.cr_ib_blob_decrypt_fileid (
a.escalation_file_id)
as file_content_blob
from compliance_eud.cr_ib_escalation_file a
where escalation_id = pv_escalation_id and active_ind = ‘Y’);
exception
when others
then
error_log_pkg.log_error_extra (gc_mod_name,
lv_proc_err_hdr,
lv_checkpoint,
‘ERROR’);
raise;
end;

able to view BLOB from toad


This returns data when i view from toad:
DECLARE
PV_ESCALATION_ID NUMBER;
PV_CR_IB_EDIT_ESC_COL_T COMPLIANCE_EUD.cr_ib_edit_esc_col_t:=COMPLIANCE_EUD.cr_ib_edit_esc_col_t();

BEGIN
PV_ESCALATION_ID := 3143;
– PV_CR_IB_EDIT_ESC_COL_T := NULL; Modify the code to initialize this parameter

COMPLIANCE_EUD.CR_IB_ESCALATION_LOAD_PKG.PRC_GET_ALL_ATTACHMENT_BY_ESCID ( PV_ESCALATION_ID, PV_CR_IB_EDIT_ESC_COL_T );
open :rc for select *from table(PV_CR_IB_EDIT_ESC_COL_T);
COMMIT;
END;

Not able to view BLOB from POSTMAN