Hello Every one,
I am trying to execute the following SQL :
insert into RES_HIST_TEMP
(
PACKAGE_ID,
PARTNERID,
TREATMENT,
TREATMENT_VAL,
RESPONSE_SK,
RESP_DDTM,
RESP_DT,
RESP_INFO_D1,
RESP_INFO_D2)
select PACKAGE_ID,
PARTNERID,
1001,
'S',
900000005,
to_timestamp("DATE",'YYYY-MM-DD HH24:MI:SS'),
"DATE",
CODE,
DEV_TYPE||' '||DEVICE_OS
from RESP_KONT_VIEW
where type <> 'send'
and seq_no = 1881111
I got an error ORA-00904 :"RESP_DDTM" Invalid Identifier
RESP_DDTM is not null Timestamp(6) in table
How can I resolve this error?
BR,
Mohammed