3 Replies Latest reply: Jan 23, 2012 12:28 PM by "Andrei Costache, Oracle-Oracle" RSS

    Less than operator problem

    pallis
      <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
      <Configs>
      <Row><cname>APPROVALS_HISTORY_CONFIG</cname><sconfig>N</sconfig><att1>N</att1><att8>N</att8><att9>4</att9><att10>4</att10><commit>BULK</commit><frequency>10000</frequency><purgeopt>A</purgeopt></Row>
      </Configs>
      <Configtables>
      <Row><tablename>APPROVALS_HISTORY</tablename><parenttablename>NULL</parenttablename><drivingtable>Y</drivingtable><lookuptable>0</lookuptable><tablelevel>1</tablelevel><attribute1>282</attribute1><attribute2>45</attribute2></Row>
      </Configtables>
      <Configcriteria>
      <Row><jointype>AND</jointype><criterianame>TILL_DATE</criterianame><criteriaseq>1</criteriaseq><tablename>AME_APPROVALS_HISTORY</tablename><columnname>ROW_TIMESTAMP</columnname><operator>*:LT;*=</operator><valuetype>VALUE</valuetype><valuedatatype>DATE</valuedatatype><valueformat>DD-MON-YYYY</valueformat><value>$TILL_DATE</value><value1>NULL</value1><value2>NULL</value2><attribute1>Y</attribute1><attribute3>Dependent</attribute3><attribute4>Y</attribute4></Row>
      </Configcriteria>
      <Objectexecutestatements>
      </Objectexecutestatements>
      
      My problem is
      We are using this xml to upload the tables in front end. The problem is when we run our application the "<"(less than) operator is not working. Can you please give me to to resolve this issue. The problem which I'm facing is kept in bold letters. When we keep ">"(Greater than) operator its working fine.
      
      Thanks & Regards,
      pallis                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
        • 1. Re: Less than operator problem
          678896
          Dear Pallis,
          This is non related to your thread.. this is a request...
          I found you on another thread regarding "Supplier2" schema tables and data...
          I really appreciate if you have those.. please let me know.. this is very needfull for me..
          Thanks ..
          Sri.
          • 2. Re: Less than operator problem
            AlexAnd
            &_gt; 
            &_lt;
            without _
            ?
            SQL> select xmlelement("E",
              2    xmlelement("D", dummy)
              3    , xmlelement("OP1", '<_')
              4    , xmlelement("OP2", '>_')
              5  )
              6  from dual
              7  /
            
            XMLELEMENT("E",XMLELEMENT("D",DUMMY),XMLELEMENT("OP1",'<'),XMLELEMENT("OP2",'>')
            --------------------------------------------------------------------------------
            <E><D>X</D><OP1>&_lt;</OP1><OP2>&_gt;</OP2></E>
            
            SQL> with t as(
              2  select xmlelement("E",
              3    xmlelement("D", dummy)
              4    , xmlelement("OP1", '<_')
              5    , xmlelement("OP2", '>_')
              6  ) xml
              7  from dual
              8  )
              9  select x.o1, x.o2
             10  from t, 
             11  xmltable(
             12           '*' passing xml
             13           columns o1  varchar2(10) path '/E/OP1'  
             14           , o2  varchar2(10) path '/E/OP2'
             15           ) x 
             16  /
            
            O1         O2
            ---------- ----------
            <_          >_
            
            SQL> 
            also without _

            Edited by: AlexAnd on Nov 17, 2011 2:25 AM
            • 3. Re: Less than operator problem
              &quot;Andrei Costache, Oracle-Oracle&quot;
              Hi Pallis,

              This is the Oracle Berkeley DB XML (BDB XML or DBXML) forum. You were likely looking to post your question on the Oracle XML DB (XMLDB) forum, XML DB.

              Regards,
              Andrei