Oracle ORA-00900:invalid SQL statement

Akalpit
2007-07-10
2013-04-25
  • Akalpit
    Akalpit
    2007-07-10

    Hi,

    In Oracle I am trying to call the procedure. I am constantly getting this error. I am using Oracle 9.2.0.8

    I am able to connect to oracle DB and fetch results thru SQL but for calling procedure getting this error

    TestSQLUnit_Test_2: Create Resource Assignment
    net.sourceforge.sqlunit.SQLUnitException: Assertion "exception-matches" failed (result != exception) *** expected: <result />
    *** but got: <result>
       <exception>
         <code>900</code>
         <message>ORA-00900: invalid SQL statement</message>
       </exception>
    </result>

     
    • Akalpit
      Akalpit
      2007-07-11

      Any updates on this. I am able to execute ms-sql procedure but it is failling to execute proc in Oracle. I used all the posible oracle jdbc drivers. I request to help me  on this

       
    • Akalpit
      Akalpit
      2007-07-11

      this is test case I am executing. but getting above exception in oracle

      <test name="TestSQLUnit_Test_3: Confirmation of XID in ant_in_id_hal table">
        <call connection-id="2">
           <stmt>
         
              {call anp_in_hal_del(?,?)}
             
           </stmt>
          <param id="1" name="xid" type="CHAR" inout="in">anhig000000000000019</param>
          <param id="2" name="xtime_stamp" type="VARCHAR" inout="in">ts</param>
        </call>
      <result>
      </result>
      </test>