Hi,
I am getting a ORA-28113: policy predicate has error when using an IN select statement.
When i use the predicate RAS_OTE_ID IN (1126) or RAS_OTE_ID = 1126 all works fine.
But when i use the predicate below i am getting the error of ORA-28113:
realm => q'[RAS_OTE_ID IN ( SELECT RAS_OTE_ID FROM ( SELECT MR.OTE_ID RAS_OTE_ID FROM GEBRUIKERS GK, RECHTENGROEPEN RGP, ORGANISATIE_RECHTEN MR WHERE GK.RGP_ID = RGP.ID AND RGP.ID = MR.RGP_ID AND UPPER(GK.GEBRUIKERSNAAM) = UPPER(XS_SYS_CONTEXT('XS$SESSION','USERNAME')) ) )]'
The table name is workingrelations and have the column name RAS_OTE_ID.
When running the select statement directly as the principal user it retuns all the id's correctly.
Any help or hint on this will be much appreciated.
Thx,
Anibal