This content has been marked as final. Show 4 replies
the above issue got fixed but i am missing .getclobval() in my query
i got another issue kindly find the details
<WFPaymentAck CompanyID="CORE" PmtTypeACKCount="1">-- how can get this value
i am able to get the below value like .
Appreciated your quick response .
thanks for the responce..
i have fixed the issue
i have used XMLAttributes to get the value
SELECT XMLELEMENT (
XMLAttributes ('1' as "TranNum",
(select distinct to_char(SYSDATE,'yyyy-mm-dd')
from DUAL) as "PrcDate"),
a.PAYMENT_ID AS "PmtID"),
a.ACK_TRANSACTION_RECEIVER AS "Name1"),
to_char(a.VALUE_DATE,'yyyy-mm-dd') as "ValueDate" ),
a.PAYMENT_AMOUNT AS "CurAmt"),
a.CURRENCY_CODE AS "CurCode")
FROM XXWAP_PAYMENT_LINE_TBL a