ORA-01840: input value not long enough for date format

[Former Member]

Hi friends,

I am facing a problem in Oracle to BI Scenario.

To send data from XI to BI, I am using Proxy Interface.

I got an error:

Error during conversion of query result to XML: java.sql.SQLException: ORA-01840: input value not long enough for date format

Please help me out.

[Former Member · Accepted solution]

hI Could you send your query.?

According Oracle FAQ you

Either add more input or shorten the date picture format, then retry the operation.

[former_member185881 · Accepted solution]

Hi

The select query is:

select * from BI_V_Calendar, (select to_char(sysdate,'YYYYMMDD') LUDT, tblIntegrationStatus.lastupdateddatesql LUSQL from tblIntegrationStatus where tblIntegrationStatus.tablename ='CALENDAR' and to_char(sysdate,'yyyy-mm-dd HH24:MI:SSSS') > to_char(tblIntegrationStatus.lastupdateddatesql,'yyyy-mm-dd HH24:MI:SSSS') and status ='READY') Ctab where CTAB.LUDT > 1 and BI_V_Calendar.MODIFIEDDATE > to_date(CTAB.LUSQL,'dd-mon-yyyy')

update query is:

Update tblIntegrationStatus set LastUpdatedDateSQL = sysdate, Status = 'DONE' where TableName = 'CALENDAR' and to_char(sysdate,'yyyy-mm-dd HH24:MI:SSSS') > to_char(LastUpdatedDateSQL,'yyyy-mm-dd HH24:MI:SSSS') and Status = 'READY'

Thanks

Dheeraj Kumar

[Former Member]

Hi Narendra,

>

Error during conversion of query result to XML: java.sql.SQLException: ORA-01840: input value not long enough for date format 

According to Oracle,

Cause: The data to be converted to date format was incomplete; the date format picture was longer than the input data.

Action: Either add more input or shorten the date picture format, then retry the operation.

So, check the date format / value and your problem will be resolved.

regards,

Neetesh

[Former Member]

Hi Narendra,

It seems some issues with your query. Please check this threads for the same issue and its solution:

http://bytes.com/topic/oracle/answers/64824-ora-01840-input-value-not-long-enough-date-format

http://www.orafaq.com/forum/t/52431/2/

http://www.dbasupport.com/forums/archive/index.php/t-33262.html

Regards,

---Satish

[iprieto]

Hi,

Check the date format value in the database. The date format picture is longer than the input data. Could you show the data send to?

Best regards

Ivá