Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Having Problem when passing values to a procedure for VPD

453187Jun 23 2006
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2006
Added on Jun 23 2006
0 comments
172 views