com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc

[Former Member]

hi

i have proxy to jdbc scenario and i am getting the below mentioned error in sxmb_moni:-

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. '_cust_sync_proc' (structure 'Statement'): java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "abc" has been invalidated ORA-04065: not executed, altered or dropped package body "abc" ORA-06508: PL/SQL: could not find program unit being called: "abc" ORA-06512: at line 1

please suggest something

Thanks

Sandhya

[iaki_vila]

Hi Sandhya,

Pi can't reach the stored procedure. Talk with you DB team if the SP package is compiled. Later, try to call the SP with DB schema before, like db_schema.Stored_procedure

Hope this helps

Regards.