ORA-01830: date format picture ends before converting entire input string in Oracle EBS

Asked Jun 04 '18 at 13:21

Active Jun 04 '18 at 13:21

Viewed 177 times

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

asked Jun 04 '18 at 13:21

Jess

5

Please show us some sample data. All it would take is one bad record to cause this. – Tim Biegeleisen Jun 04 '18 at 13:26
What's in `:p_data`? – William Robertson Jun 04 '18 at 13:37

ORA-01830: date format picture ends before converting entire input string in Oracle EBS

0 Answers0