inconsistent datatypes error
661928Oct 10 2008 — edited Oct 10 2008Hi,
I have faced on the following problem in sql statement.
SQL> SELECT B.NAME, C.FST_NAME, C.LAST_NAME FROM SIEBEL.S_PARTY_PER A, SIEBEL.S_ORG_EXT B, SIEBEL.S_CONTACT C WHERE (B.ROW_ID = A.PARTY_ID AND C.ROW_ID = A.PERSON_ID AND A.PERSON_ID IN (select D.NEW_VAL from SIEBEL.S_AUDIT_ITEM D where D.OPERATION_CD = 'Associate' and (trunc(OPERATION_DT) Between TRUNC (&from) AND TRUNC (&to))));
Enter value for from: 10/8/2008
Enter value for to: 10/10/2008
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected DATE got NUMBER
plz help me....