Re: Streams Subset-Rule issue

From: krishna sarabu <ksarabu_at_yahoo.com>
Date: Fri, 20 Jul 2007 11:09:20 -0700 (PDT)
Message-ID: <764127.61376.qm@web56204.mail.re3.yahoo.com>

Hi Alex,

Thanks. That was issue with e-mail formatting.. The actual sql looks fine..

set serveroutput on
DECLARE
  v_Cnt Number;

  v_Condn Varchar2(2000) := 'AGI_ID IN (8700,8720,8750,8760,8770,8780,8790,8800,8810,8820,8830,8840,8850,8860,8870,8930,8940,
8950,8960,8970,9010,9020,9050,9070,9080,9090,9100,9110,9120,9130,9140,9150,9160,9170,9180,
9190,9200,9210,9220,9230,9240,9250,9260,9280,9290,9300,9340,9380,9390,9400,9410,9420,9430,
9440,9450,9460,9470,9490,9550,9580,9590,9610,9640,9650,9660,9720,9820,9830,9850,9860,9870,
9880,9900,9920,9930,9940,9950,9970,9980,9990,10010,10020,10030,10050,10070,10080,10090,10100,
10110,10120,10140,10150,10170,10180,10190,10200,10210,10220,10230,10260,10270,10280,10320,
10330,10340,10350,10360,11210,11290,11300,12420,3340373,3340401,3340426,4000285,4000286,4000289,
4000291,4000297,4000298,4000301,4000307,4000308,4000314,4000315,4000316,4000317,4000321,4000322,
4000323,4000324,4000325,4000326,4000327,4000328,4000362,4000389,4669501,4669568,4669569,4669570,
4669571,4669581,5345135,5356001,5356002,5356003,5358715,5358756,5366965,5396063,5401435,5418021,
5426337,5450297,5455797,5507811,5507818,5513940,5513941,5513948,5513949,5513950,5543011,5543022,
5571228,5604007,5609411,5622904,5628516,5657811,5658706,5658713,5692808,5703815,5709007,5717009,
5724402,5724403,5768724,5769004,5791708,5796308,5812908,5818911,5833308,5843121,5854507,5865835,
5865840,5404303,5409751,5422276,5836523,5893256,5893261,5893277,5920622,5958209,6009008,6009010,

6180007,3060,2960,2980,6240,3340404,3050,5344188,5376523,5727004,5727054,5743007,5774647,5355994, 5366626,5372551,5376503,5376523,5381770,5384792,5408848,5648405,5698602,5700316)';

BEGIN   execute immediate 'select count(1) from strms_test.nts_derivative_Ts where '||v_condn into v_cnt;

  dbms_output.put_line('# Of Rows in Table : '|| v_Cnt);

  DBMS_STREAMS_ADM.ADD_SUBSET_RULES(

    table_name               =>  'strms_test.nts_derivative_ts',
    dml_condition            =>  v_Condn,
    streams_type             =>  'CAPTURE',
    streams_name             =>  'STST_CAPT01',
    queue_name               =>  'STRMADMIN.CNRTS1_Q');

END;
/

# Of Rows in Table : 175615462
DECLARE
*
ERROR at line 1:

ORA-25448: rule STRMADMIN.NTS_DERIVATIVE_TS132 has errors
ORA-00936: missing expression
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 49
ORA-06512: at "SYS.DBMS_RULE_ADM", line 178
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1205
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1073
ORA-06512: at line 25

Alexander Fatkulin <afatkulin_at_gmail.com> wrote: Do a ctrl-f for "536696 5"

you have a typo

--

Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--

http://www.freelists.org/webpage/oracle-l        

---

Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 20 2007 - 13:09:20 CDT