Skip to Content
author's profile photo
Former Member

Error when executing statement for table/stored proc. : ORA-00911

Hi All,

I am posting IDOC->XI->JDBC, approx 5000 Idocs.

But few messages are giving following error in XI-_SXMB_MONI

Can any one guide me what is the cause of error? I check whole Idoc data I am not able to see bad character? can any once guide me what are the bad character in XML to post data in oracle? so that i can search in XML and how to avoide this error.

"com.sap.aii.af.ra.ms.api.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'HRP1001' (structure 'INSERT_PAD34'): java.sql.SQLException: ORA-00911: invalid character"

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 06:25 PM

    Ok i found <PROZT>0.00 #</PROZT> data in one field which is giving problem.

    Can any one suggest me how can i replace this type of characters with blank in XI during mapping?

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      > I am talking about following IDOC.<ZRMD_A06> ->

      > <E1PLOGI SEGMENT="1">-> <E1PITYP SEGMENT="1"> ->

      > <E1PAD34 SEGMENT="1"> -><PROZT>0.00 #</PROZT>.

      > Can we remove this # during message mapping in XI??

      sure you can remove it using Replace function or by writing UDF.

      as I am seing # is last character..<b>so remove # with " " (single space) and then use the TRIM fucntion.</b>

      Thanks

      Farooq.

      *<b>Rewards points if you find it useful*</b>