cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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"

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

justin_santhanam
Active Contributor
0 Kudos

Rohan,

Does it gonna be standard? I mean will u get only one # at end all the times? Or it might change too?

raj.

Former Member
0 Kudos

Thanks for reply Raj,

I checked in some idocs its coming like <PROZT>0.00</PROZT>

and in some idocs its coming like <PROZT>0.00 #</PROZT> .

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??

Regards

justin_santhanam
Active Contributor
0 Kudos

Rohan,

Try this and let me know..

http://www.flickr.com/photo_zoom.gne?id=1449322648&size=o

raj.

Former Member
0 Kudos

USE replace function with a space when u have # for that field in ur mapping

Former Member
0 Kudos

> 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>

Answers (0)