Having Problem when passing values to a procedure for VPD
Hi
I am executing my security policy by passing the following tokens
exec app_security_context_ipay.set_Region_ccode('(130,''375988''),(130,''s1a''),(130,''S1E''),(130,''S1F''),(130,''S1H''),(130,''s25''),(130,''sb8''),(130,''SB9''),130,''SBB''),(130,''SBT''),(130,''SBU''),(130,''SBV''),(130,''scn''),(130,''SCV''),(130,''seg''),(130,''sfa''),(130,''SNB''),(130,''SNC''),130,''SPE''),(130,''SRL''),(130,''SS''),(130,''stt''),(130,''SVA''),(130,''SWK''),(130,''SWM''),(130,''SXB''),(130,''SXC''),(130,''SXD''),130,''SXE''),130,''SXX''),130,''SY8''),130,''SZ''),(130,''SZ4''),(130,''SZ5''),(130,''SZD''),(130,''szs'')');
**************************************************
and then when I run the query it gives me the error that the Policy Predicate has an error. I Looked up in the dump file the following error was there.
Error information for ORA-28113:
Logon user : CRUVPD
Synonym : CRUVPD.T_IPAY_USER
Policy name : TIPAYUSER_IPAY_POLICY
Policy function: SECUSR.OE_SECURITY_IPAY.REGION_CCODE_SEC
RLS predicate :
(REGCODE,CCODE) in ((130,'375988'), (130,'s1a'),(130,'S1E'),(130,'S1F'),(130,'S1
H'), (130,'s25'),(130,'sb8'),(130,'SB9'), (130,'SBB'),(130,'SBT'),(130,'SBU'), (
130,'SBV'),(130,'scn'),(130,'SCV'), (130,'seg'),(130,'sfa'),(130,'SNB'), (130,'S
NC'),(130,'SPE'),(130,'SRL'), (130,')
ORA-00920: invalid relational operator
ORA-00920: invalid relational operator
***********************************************
It seems like it is truncating the rest of the tokens and making the Predicate Function to produce an error.
How can I pass the Values that exceed the lenght of the sqlplus size.
I have tried to give line breaks and also tried to use the - for line continuation but still not working.
I need the solution Badly and Urgently, Any Help would be greatly Appreciated.
Thanks