Insert with date format
DalberiNov 11 2009 — edited Nov 11 2009Hi,
I've a problem with an insert, I wont to insert a record with one date column that I extract from data_picker_item, like this:
insert into backup_adm.tmp_job_runs@REP920DC_LNK values
(:P3_OPCO,
16642,
to_char(to_date(:P3_TIMESTAMP,'DD/MM/YYYY hh24:mi')),
to_date('05/11/09 18:34','dd/mm/yy hh24:mi'),4,-1,2,1);
I.ve receive this error:
ORA-01461: can bind a LONG value only for insert into a LONG column ORA-02063: preceding line from REP920DC_LNK