Problem with JDBC Adapter, Lookup API, ORA-00900

[Former Member]

Hello,

I am facing some problem with LookupAPI with ORA-900 like,

Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): java.sql.SQLException: ORA-00900: invalid SQL statement

Can any one help me in this regard...

Its a RFC to JDBC scenario..

there is sync call from RFC with some parameters..

those parameters are used by some SQL Queries at DB side and the response will come from one of the queries which reads the results of the stored procedure where this execution of SP at Db side is one of the query..

at last the data is deleted frmDB..

so there are 4 queries,

1. to insert data (params)

2. to execute a SP

3.. to read the results of the SP which returns some data( This is the response for the sync call from RFC call)

4. deletes the data from DB..

Please do the due.

Thanks

Soorya

[VijayKonam]

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

VJ