I am doing one scenario where oracle is the receiver. in the mapping i have field entry_date my source date format is yyyymmdd & i need to convert this into dd-mon-yy hh:mm:ss.
i used the date tranformation logic dd-MMM-yy HH:mm:ss. and when i tested it's working fine. but when it reaches data base i am getting the ORA-01830: date format picture ends before converting entire input string in jdbc eeror.
i tried the below link
In UDF which i need to select single values Or queue?
argument or paramenter?
If we need UDF then tell me what is i need to do. please share the code & step by procedure i never used UDF.