My Oracle Support Banner

Target Table Is Not Updating Through Oracle Streams Getting ORA-00904 For The BLOB Column (Doc ID 2505121.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Target table is not updating through oracle streams getting ORA-00904: invalid identifier  when apply process performs Update statement  for the BLOB Column type .

 

Setting event 904 errorstack reports, for the Apply Server:

 

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-00904: : invalid identifier
----- Current SQL Statement for this session (sql_id=2khxhyx1s9rrg) -----
update /*+ streams or_expand(p "DOCUMENT_STORAGE_DATE" "ENTITY_NUMBER" "FILE_NAME" "IS_STREAMED" "PATH" )restrict_all_ref_cons  */  "<OWNER>"."<TABLE_NAME>" p set "DATA"=dbms_reputil2.get_final_lob(:1,"DATA",:2), "DMS_REF_ID"=decode(:3,'N',"DMS_REF_ID",:4), "DOCUMENT_STORAGE_DATE"=decode(:5,'N',"DOCUMENT_STORAGE_DATE",:6), "ENTITY_NUMBER"=decode(:7,'N',"ENTITY_NUMBER",:8), "FILE_NAME"=decode(:9,'N',"FILE_NAME",:10), "IS_STREAMED"=decode(:11,'N',"IS_STREAMED",:12), "PATH"=decode(:13,'N',"PATH",:14) where (:15='N' or((:16='N' or(dbms_lob.compare(:17,"DATA")=0)or(:17 is null and "DATA" is null)) and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1)) and(:18="DMS_REF_ID") and(:19="DOCUMENT_STORAGE_DATE" or(:19 is null and "DOCUMENT_STORAGE_DATE" is null)) and(:20="ENTITY_NUMBER" or(:20 is null and "ENTITY_NUMBER" is null)) and(:21="FILE_NAME" or(:21 is null and "FILE_NAME" is null)) and(:22="IS_STREAMED" or(:22 is null and "IS_STREAMED" is null)) and(:23="PATH" or(:23 is null and "PATH" is null))

 

Call Stack:
++++++++++++++++

kzpchkbu ksfchk kglchk3 kglchk2 kglchk1 qcsRslvPLSQLInvoc1 qcsRslvPLSQLInvoc qcsRslvName qcsridn qcsnrupd qcsraic qcspqbDescendents qcspqb kkmdrv opiSemp opiprs kksParseChildCursor rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.