SAP CLM - CALL Stored Procedure

[Former Member]

Hello Folks,

I have a Oracle package that I need call from SAP CLM.

I see the link in help.sap.com SAP E-Sourcing about <Query Definition: "Stored Procedures and Queries">, but not success.

I call the package from SAP CLM

{CALL <%SCHEMA%>.PKG_CLM.PRC_ADT(?,<%CURRENT_USER_ENTERPRISE%>,<%CURRENT_USER_ID%>)}

and received the error message:

Exception SQL: Invalid column index, state SQL ANSI-92: null, error code from provider: 17003

Anybody have some sugest ?

Thanks in advanced.

[former_member190023]

Hi Carlos,

By the looks of the error it seems that there is a mismatch between the CLM Result Fields and the cursor returned by the stored procedure.

You should have the same number of result fields as columns in the cursor. Additionally, the data types should match as well.

Bogdan