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

Last updated on APRIL 17, 2023

Applies to:

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

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