Hi,
Could you tell me the logic for below.
In my package, I will get more than one record for the column " credit_offers " , How should i make this column as a table type and assign values to it.
TYPE sr_rec_type IS RECORD
(task_status apps.jtf_task_statuses_tl.name%TYPE
,task_type apps.jtf_task_types_tl.name%TYPE
,jt_new_res_id apps.jtf_task_assignments_audit_b.new_resource_id%TYPE
,jt_source_name apps.jtf_rs_resource_extns.source_name%TYPE
,credit_offers apps.qa_results_v.character1%TYPE
);
TYPE sr_tbl_type IS TABLE OF sr_rec_type
INDEX BY BINARY_INTEGER;
PROCEDURE service_record(p_service_req_num IN VARCHAR2
,p_service_req_tbl OUT sr_tbl_type
);
Thanks.