Skip to Content
0
Oct 03, 2012 at 09:01 AM

date conversion error ORA-01830: date format picture ends before converting entire input string in jdbc

455 Views

Dear expert,

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

http://scn.sap.com/message/13145628

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.

Regards,

pavan

Attachments

mapping.PNG (40.0 kB)
result.PNG (5.5 kB)