11 Replies Latest reply on Nov 3, 2012 7:56 AM by Tina.Wang-Oracle

    ORA-00911: invalid character error.

    lony
      HI All,

      I am using ODI 11g and Oracle 11 g.

      I am using the below query in proc in ODI.While inserting data in table it says ORA-00911: invalid character error.
      INSERT INTO SD_CAMP
      SELECT DISTINCT CAMPGN_NO, PRODUCT, NULL,
      CAMPG_NAM, trunc(sysdate), trunc(sysdate)+182
      FROM SP_ODI_TEMP;

      I have also inserted the value as hard coded in ODI but still it says the same error.
      INSERT INTO SD_CAMP values('SAS06','SBC',NULL,'SB CUST TO FFT',TO_DATE('02-NOV-12','DD-MON-YY'),
      TO_DATE('03-MAY-13','DD-MON-YY'));

      i ran this query in Oracle db but its working fine.

      Any help how to resolve this?

      Thanks,
      Lony