Plz help me with the issue while invoking a Store Procedure call

, ,
1

Hi,

I went through different threads in the forums for my issue but couldnt able to figure it out. Could someone plz suggest me a solution for the following problem.

I was encountered with the following error when trying to invoke the store procedure call. Could someone tell me what might have gone wrong or what changes might make that to work?

–
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service PO.Adapter.DB:PO_Error_Log_SP.
[ADA.1.316] Cannot execute the SQL statement “{call abc.def_M2A_ERROR.LOG_ERROR (?, ?, ?, ?, ?, ?, ?) }”. "
(65000/6550) ORA-06550: line 1, column 7:
PLS-00201: identifier ‘abc.def’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
ORA-06550: line 1, column 7:
PLS-00201: identifier ‘abc.def’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignore

Appreciate your responses.

2

Alex,
Few thoughts:
1- Are you using the correct/complete (If no synonym defined) name of the SP (Store Procedure)? It could be that the SP is defined/stored under a different DB userid than the one you are using to execute it.
2- Have permissions to exectue the SP?
3- Plz make sure that you are using the correct signature of the SP.

~tS

3

Thanks Tahira…That worked and appreciate your input.