ORA-22275 When Attemptings To Update A LOB Column That Has An FGA Policy Enabled
Last updated on AUGUST 21, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Getting ORA-22275 when attempting to update a LOB on a table that has an FGA policy enabled.
- This error only happens when there is a LOB on the audited table.
- Also, issue does not rise if FGA policy is disabled.
- The problem started after upgrading to 18.104.22.168 or 22.214.171.124 from 126.96.36.199
- Worked fine under 188.8.131.52
While analyzing the trace we can see this oddity:
PARSING IN CURSOR #614111472 len=129 dep=0 uid=17523 oct=6 lid=17523 tim=53447461735 hv=3571669420 ad='7ffa5cd13e8' sqlid='gf9uc1zaf6qdc'
"ROWID" = :"Old_ROWID"
END OF STMT
value=FGA Policy Audit Initialization has Error 22275
ERROR #614111472:err=22275 tim=53447464092
We can see that the bind #1 is being replaced from a CLOB pointer to "Varchar2 value of an error".
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