Analytics Software

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