Reputation: 11
I'm trying to fix and error in a XML script to make a concurrent in Oracle EBS, but i'm not having success. I need to convert a parameter 'type=date 'to "dd/MM/yyyy", but everything i try, nothing works. This error is persisting everytime.
My parameter is "parameter name="P_DATA" dataType="date""
My select is "SELECT To_char(:P_DATA, 'dd/MM/yyyy') C_DATA FROM DUAL"
Please, someone help me to fix this. Thankss
Upvotes: 0
Views: 241