ORA-22275 When Attemptings To Update A LOB Column That Has An FGA Policy Enabled (Doc ID 2192191.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

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 11.2.0.4 or 12.1.0.2 from 11.2.0.3
- Worked fine under 11.2.0.3

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'
UPDATE "SYG"."IQ_FGA_TEST"
SET
 "CL_REMRQ"=EMPTY_CLOB()
WHERE
 "ROWID" = :"Old_ROWID"
RETURNING
 "CL_REMRQ"
INTO
 :"CL_REMRQ"
END OF STMT
PARSE #614111472:c=0,e=291,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=53447461733
BINDS #614111472:
Bind#0
 value="AAQ/PMAAYAAHcHdAAB"
Bind#1
 value=FGA Policy Audit Initialization has Error 22275
EXEC #614111472:c=0,e=2275,p=0,cr=2,cu=28,mis=1,r=0,dep=0,og=1,plh=3919692340,tim=53447464080
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".


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