Hi All,
My objective is to display the value of c012 in multiple lines in a classic report and I'm using the following code
declare
lv_res varchar2(500);
begin
for i in (
select seq_id, c001, c012
from apex_collections
where collection_name = 'COL_1') loop
if i.c001 = 'A' then
lv_res := 'The value is A';
else
lv_res := 'The Value is something else';
end if;
apex_collection.update_member_attribute(
p_collection_name => 'COL_1',
p_seq_id => i.seq_id,
p_attr_number => '12',
p_attr_value => lv_res);
end loop;
end;
/
Intended Output
----------------------
Classic Report
| Seq ID | C001 | C012 |
|---|
| 1 | A | The value is A |
| 2 | B | The Value is something else |
Note :
(1) If i use char(13) and chr(10); it works fine with dbms_output.put_line; but has no effect on the classic report.
(2) Used <br/> to make the value of lv_res multi line, but has no effect on the classic report.
(3) Tried using htp.p; but got error saying p is not recognized.
Thank You