java.sql.SQLException: ORA-00911: invalid character

[ravi_reddy1]

Hello Experts,

My scenario is Proxy to JDBC.

Every day lot of invoices are flow from ECC to PI and further sent to Database using JDBC adapter.

To day  in Message monitoring I saw one invoice is stuck in pi production system, once I checked in details tab in message monitoring it gives the following error.

Where exactly error occurs i.e in payload or receiver jdbc structure?

Please do the needful

Regards,
Ravi

[bhavesh_kantilal]

Did you follow the steps that have been listed in the previous question you had raised?

http://scn.sap.com/thread/3897159

As far as I can see it seems to be the same Interface but with a slight difference in error. The steps to debug continue to remain the same. Please make sure you either close previous threads / discussion and avoid duplicates.

As folks have mentioned this is again an issue with your payload and as the error implies a reserved character is used. Did you download the payload, did you check the same?

Regards,

Bhavesh

[iaki_vila]

Hi Ravi,

Check your payload because you probably use a reserved character: Oracle/PLSQL: ORA-00911

Regards.

[Bhargavakrishna]

Hi Ravi,

Any changes to the stored procedures recently? check if it is working or not?

or

Please check your statement you might be using invalid character.

Regards

Bhargava Krishna

[ravi_reddy1]

Hi Bhargava,

not done any changes.

I checked the payload and no issues

Regards,
Ravi