oracle10g - ORA-01858 Oracle Date Problem while inserting from java -


i have code in application inserts java.sql.timestamp oracle date column. code works fine. error :

ora-01858: non-numeric character found numeric expected.  

when see log, similar inserts executed @ same time successful , of sudden 1 particular operation fails. when @ format between different statements, similar. not guess problem.

the first statement failed. second has got inserted successfully.

insert omtm_execute_report(er_id_pk,er_oms_order_id,er_orig_oms_order_id,er_esis_no,er_transaction_no,er_exec_trans_type,er_exec_type,er_ord_status,er_order_rej_reason,er_cust_account,er_settle_type,er_fut_settle_dt,er_security_type,er_symbol_code,er_action,er_ord_quantity,er_ord_type,er_price_per_share,er_stop_price_per_share,er_currency_id,er_time_in_force,er_expire_time,er_last_trd_shares,er_traded_price_per_share,er_leaves_quantity,er_cumulative_qty,er_average_price,er_transact_time,er_trade_date,er_text,er_can_rej_response_to,er_can_rej_reason,er_disclosed_quantity,er_fill_quantity,er_read_flag,er_settle_flag,er_exec_rep_time,er_modified_datetime)       values      (omsq_tm_id_pk.nextval,5168,0,08434308,0436594708434308,0,2,2,null,0079027076,9,null,null,aldar,buy,100000,2,5.33,0.0,0,0,2009-12-17 00:00:00.0,100000,5.33,0,100000,5.33,2009-12-17 06:01:54.0,2009-12-17 06:01:54.0,hold created inspite of insufficient bal,null,null,0,0,'n','n',sysdate,sysdate)   insert omtm_execute_report(er_id_pk,er_oms_order_id,er_orig_oms_order_id,er_esis_no,er_transaction_no,er_exec_trans_type,er_exec_type,er_ord_status,er_order_rej_reason,er_cust_account,er_settle_type,er_fut_settle_dt,er_security_type,er_symbol_code,er_action,er_ord_quantity,er_ord_type,er_price_per_share,er_stop_price_per_share,er_currency_id,er_time_in_force,er_expire_time,er_last_trd_shares,er_traded_price_per_share,er_leaves_quantity,er_cumulative_qty,er_average_price,er_transact_time,er_trade_date,er_text,er_can_rej_response_to,er_can_rej_reason,er_disclosed_quantity,er_fill_quantity,er_read_flag,er_settle_flag,er_exec_rep_time,er_modified_datetime)        values      (omsq_tm_id_pk.nextval,5170,0,08434400,0436599708434400,0,2,2,null,0059729784,9,null,null,sorouh,sell,82574,2,2.83,0.0,0,0,2009-12-17 00:00:00.0,82574,2.83,0,82574,2.83,2009-12-17 06:04:48.0,2009-12-17 06:04:48.0,null,null,null,0,0,'n', 'n',sysdate,sysdate) 

any highly appreciated

thanks

2009-12-17 06:01:54.0 not valid timestamp literal oracle

you need use: timestamp '2009-12-17 06:01:54.0'

although it's surprising 1 of statements works


Comments

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -