You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ICS-10064 error when calling a stored procedure with the ADW adapter

edited Mar 2, 2020 8:41PM in Integration 2 comments

Content

I'm having trouble invoking a stored procedure using the ADW adapter in a scheduled orchestration.

My procedure is very simple:

create or replace PROCEDURE procedure_name (dummy_var IN NUMBER, dummy_var2 IN NUMBER) IS
BEGIN
update table1
    set 
        column1 = (select max(some_value) from table2);
END;

(The dummy variables are not used. same error is raised when not including them in the procedure.)

This leads to the error:

An error occurred while preparing mapper object. [Cause: Root Element is Invalid for the Target URI ''{0}''] ICS-10064 : An error occurred while preparing mapper object. Root Element is Invalid for the Target URI ''InputParameters''

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!