Hello All,
We trying to pass the following insert statement ,
INSERT INTO CDN_CUSTOMER_REFERENCE(FORMID,FORMCOUNTRY,CLIENTLIST,CLIENTLIST_NAME,CLIENTLIST_EMAIL,TESTIMONIAL,PRESSANALYST,PRESSRELEASE,VIDEO,PRINTEDCS,SITEVISIT,SPEAKING,COMMENTS,FIRSTNAME,LASTNAME,CONTACTNUM,JOBTITLE,COMPANY,COUNTRY,EMAIL,COLTAE,TELEPHONE,SUBMITTED) VALUES ('CUSTOMER_REFERENCE_PROGRAM','uk','Client List','','','','Press/analyst interview','','','','','','','sgdf','sdfsf','sfgdg','s\dsdf','\sdfsdf','\sdfsdf','x.y@zt.net','asdsad',sysdate)
DESC CDN_CUSTOMER_REFERENCE
Name Null Type
---------------- -------- -------------
FORMID VARCHAR2(100)
FORMCOUNTRY VARCHAR2(50)
CLIENTLIST VARCHAR2(100)
CLIENTLIST_NAME VARCHAR2(100)
CLIENTLIST_EMAIL VARCHAR2(100)
TESTIMONIAL VARCHAR2(50)
PRESSANALYST VARCHAR2(50)
PRESSRELEASE VARCHAR2(50)
VIDEO VARCHAR2(50)
PRINTEDCS VARCHAR2(50)
SITEVISIT VARCHAR2(50)
SPEAKING VARCHAR2(50)
COMMENTS VARCHAR2(300)
FIRSTNAME VARCHAR2(100)
LASTNAME VARCHAR2(100)
CONTACTNUM VARCHAR2(50)
JOBTITLE VARCHAR2(50)
COMPANY VARCHAR2(50)
COUNTRY VARCHAR2(50)
EMAIL NOT NULL VARCHAR2(100)
COLTAE VARCHAR2(50)
TELEPHONE VARCHAR2(50)
SUBMITTED DATE
We are getting the error SQL Error: ORA-00947: not enough values,we did check the table and compared the columns and the values given if they have any difference but we found there are 23 Columns and we are giving 23 values too.
Help is very much appreciated.
Thanks