Production Problem Help Needed From GURUS
453187Jun 23 2006 — edited Jun 25 2006I 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