Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00904 and TIMESTAMP(6)

mmoayedMay 13 2019 — edited May 14 2019

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

This post has been answered by Choc Cac on May 13 2019
Jump to Answer
Comments
Post Details
Added on May 13 2019
5 comments
958 views