JDBC error

[Former Member]

My scenario is File(xml) to JDBC.

I got the following error

<b>Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'BPSAI_SAP_RECEIVABLES' (structure 'Invoice'): java.sql.SQLException: ORA-00928: missing SELECT keyword</b>

my action is INSERT

Why it is giving the error like this?

[Former Member]

Hi

action Attribute is expecting a SELECT command and you have given an INSERT.Change it to SELECT.

But according to the Scenario you must have an INSERT, so check the stored procedure.

Thanks

[Former Member]

Hi,

Check the action attribute in the JDBC receiver.

It should have value as "SELECT".Check the JDBC payload structure in sxmb_moni

Most probable reason would be the receiver side datatype for JDBC. Recheck with this

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Mahesh

[nisarkhan_n]

Refer this thread...

might be helpfull

[prateek]

Check the action attribute in the JDBC receiver. It should have value as "SELECT".

Check the JDBC payload structure in sxmb_moni

Most probable reason would be the receiver side datatype for JDBC. Recheck with this

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Prateek