ORA-00932 In Select With To_timestamp In Vb And .Net After Database Upgrade to 10.2.0.4.0 (Doc ID 739885.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.4 to 10.2.0.5 - Release: 10.2 to
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.5   [Release: 10.2 to 10.2]
Information in this document applies to any platform.

Symptoms

After upgrading the Oracle database from 10.2.0.3.0 to 10.2.0.4.0 when executing the the following
sql results in the error:
ORA-00932: inconsistent datatypes: expected - got -

Sql:
SELECT SESSIONID, SPARE1 OS_USERNAME, USERID USERNAME,
TO_CHAR(NTIMESTAMP#, 'DD/MM/YYYY HH24:MI:SSXFF') TIMESTAMP,
TO_CHAR(AUD.ACTION#,'99999') ACTION#, SUBSTR(ACT.NAME,1,28) ACTION,
TO_CHAR(RETURNCODE,'999999') RETURNCODE,
OBJ$CREATOR OBJ$CREATOR, OBJ$NAME OBJ$NAME,
TO_CHAR(STATEMENT,'9999') STATEMENTID,
SUBSTR(COMMENT$TEXT,1,200) COMMENT_TEXT, USERHOST, TERMINAL,
AUTH$PRIVILEGES, AUTH$GRANTEE, NEW$OWNER, NEW$NAME,
SES$ACTIONS, SES$TID, LOGOFF$LREAD, LOGOFF$PREAD, LOGOFF$LWRITE,
LOGOFF$DEAD, LOGOFF$TIME, CLIENTID, SPARE2,
PRIV$USED, SESSIONCPU, ENTRYID, PROXY$SID, USER$GUID, INSTANCE#,
PROCESS#, XID, AUDITID, SCN, DBID,
TO_CHAR(SQLBIND) SQLBIND, TO_CHAR(SUBSTR(SQLTEXT,1,4000)) SQLTEXT
FROM SYS.AUD$ AUD, AUDIT_ACTIONS ACT
WHERE AUD.ACTION# = ACT.ACTION (+)
AND NTIMESTAMP# BETWEEN TO_TIMESTAMP(:di, 'YYYYMMDDHH24MISS')
AND TO_TIMESTAMP(:df, 'YYYYMMDDHH24MISS')


Changes

The Oracle Database was upgraded from 10.2.0.3.0 to 10.2.0.4.0.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms