Skip to Content
avatar image
Former Member

Problem with JDBC Adapter, Lookup API, ORA-00900

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 15, 2008 at 07:30 PM
    Add comment
    10|10000 characters needed characters exceeded