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!

getting error in Insert statement

AmywilsonApr 1 2020 — edited Apr 2 2020

Hi Gurus

I am working on Oracle 12.2.0.1.0.

I have created a table and trying to insert data into table. But was not able to load it. Can you please help me to insert data without any issues.

CREATE TABLE USER_TYPE

   ( ID_TYPE VARCHAR2(13 BYTE) NOT NULL ,

DESCRIPTION VARCHAR2(255 BYTE),

REC_STS_CODE CHAR(1 BYTE) NOT NULL ,

INSERT_USER VARCHAR2(20 BYTE) NOT NULL ,

INSERT_PROCESS VARCHAR2(80 BYTE) NOT NULL ,

INSERT_TIMESTAMP TIMESTAMP (6) NOT NULL ,

UPDATE_USER VARCHAR2(20 BYTE),

UPDATE_PROCESS VARCHAR2(80 BYTE),

UPDATE_TIMESTAMP TIMESTAMP (6),

UPS_SRC_NUMBER NUMBER,

O_INSERT_TIMESTAMP TIMESTAMP (6),

O_UPDATE_TIMESTAMP TIMESTAMP (6)

   );

  

 

 INSERT INTO USER_TYPE VALUES('100','ORACLE PRODUCT','A','K12345','MANUAL',sysdate,'<null>','<null>','<null>','','','');

  

  

ORA-01858: a non-numeric character was found where a numeric was expected

  

   if I put  to_char(sysdate) instead of SYSDATE then also getting the error ORA-01843: not a valid month.

  

   Can you please help me to correct the syntax and load the data.

Thanks

Amy.

Comments
Post Details
Added on Apr 1 2020
8 comments
555 views