Oracle ORA-00900:invalid SQL statement

  • Akalpit

    Akalpit - 2007-07-10


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

    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>
         <message>ORA-00900: invalid SQL statement</message>

    • 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">
              {call anp_in_hal_del(?,?)}
          <param id="1" name="xid" type="CHAR" inout="in">anhig000000000000019</param>
          <param id="2" name="xtime_stamp" type="VARCHAR" inout="in">ts</param>


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks