I AM TRYING TO GENERATE AN XML REPORT FROM RELATIONAL TABLE:
Why use XMLFOREST ? :
There is a "Transfer" BLOCK in the XML Report which I want to omit from the report if all the fields inside the block are NULL.
The problem is with the XMLFOREST BLOCK in the SQL code which is not returning the TAG <Transfer> in the output.
WHAT I AM DOING IS :
rownum AS "recordId",
TO_DATE('20130520','YYYYMMDD') AS "dateCorrected",
123456 AS "previousBatchId",
56789 AS "previousRecordId"
SIG_ROLE AS "SignatoryRole",
TO_CHAR(TRANSFER_DATE,'YYYY-MM-DD') AS "TransferDate",
NVL(REASON,0) AS "Reason"
) AS "Transfer"
) AS CRDTRPT
FROM ANY_TABLE a
WHICH GIVES ME : I am not getting the <Transfer> TAGS here.
WHAT I WANT IS :
Any promt reply or hint to solve this issue will be greatly appreciated.
(I think I am doing Something Silly, which is the cause of this.)
Perfect !!! Thanks for the prompt reply !!