Oracle ORA-00900:invalid SQL statement

[Akalpit]

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]

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]

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>