I am trying to create a collection driven report on a Master Detail Form.
I created a Procedure:
create or replace
PROCEDURE Processors_Coll_Prcdr(var_auditorID VARCHAR2) AS
i pls_integer;
iCtrRigheVuote pls_integer := 15;
BEGIN
--Initiate the Collection Item
apex_collection.create_or_truncate_collection('PROCESSOR_COLLECTION');
FOR Rec IN (
select sa.STAFFASSIGNID, sa.AUDITORID, sa.PROCESSORID
from LC_STAFFASSIGNMENT sa
where sa.AUDITORID = var_auditorID
)
LOOP
apex_collection.add_member(
p_collection_name => 'PROCESSOR_COLLECTION',
p_c001 => Rec.STAFFASSIGNID,
p_c002 => Rec.AUDITORID,
p_c003 => Rec.PROCESSORID);
END LOOP;
FOR i IN 1..iCtrRigheVuote
LOOP
apex_collection.add_member(
p_collection_name => 'PROCESSOR_COLLECTION',
p_c001 => 0,
p_c002 => NULL,
p_c003 => NULL);
END LOOP;
END Processors_Coll_Prcdr;
And then called the function in a process located in Before Header:
BEGIN
Processors_Coll_Prcdr(var_auditorID => :P81_AUDITORID);
END;
I then created a classic form and used the following as the source:
SELECT rownum,
apex_item.hidden(1, c001) Staff_Assign_ID, --Key ID
apex_item.text(2, c002, 8, 8) Auditor_ID,
apex_item.text(3, c003, 3, 3) Processor_ID
FROM APEX_COLLECTIONS
WHERE COLLECTION_NAME = 'PROCESSOR_COLLECTION'
Now when I run the page, I get the data I want but it is encapsulated in HTML tags. I looked at the Report Attributes and Strip HTML is set to Yes.
How do I correct the HTML encapsulation?
Thanks.