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!

Production Problem Help Needed From GURUS

453187Jun 23 2006 — edited Jun 25 2006
I have the following procedure
******************************************
create or replace package app_security_context_ipay AS

procedure set_region_ccode(i_regionccode IN varchar2);

END;

/



-- Create package Body which has access to set the context variables



CREATE OR REPLACE PACKAGE BODY APP_SECURITY_CONTEXT_IPAY AS

PROCEDURE SET_REGION_CCODE (i_regionccode IN varchar2)

IS

BEGIN

DBMS_SESSION.SET_CONTEXT('app_context_ipay','region_ccode',i_regionccode);



END;

END;

/
******************************************************

I have to Pass a long string in it that is
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'')');

BUT when I pass the string it is truncating after 255 characters.

How can I pass the string to set my predicate to function properly

The Following error I got from the dump file

*** 2006-06-23 16:42:12.103

-------------------------------------------------------------

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

ANY Help is greatly appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2006
Added on Jun 23 2006
6 comments
511 views