Null Pointer Exception while calling store procedure from rule

Hi All,

I'm trying to call a store procedure from an expression rule. It looks the below:

with(
local!SPresult: executestoredprocedure(
dataSourceName: "jdbc/----",
procedureName: "CLU.TEST1"
),
local!SPresult
)

When executed, it throws the following error:

success: false error: "java.lang.NullPointerException at com.appiancorp.ps.function.ExecuteStoredProcedureFunction.getMatchingProcedureInput(ExecuteStoredProcedureFunction.java:357) at com.appiancorp.ps.function.ExecuteStoredProcedureFunction.validate(ExecuteStoredProcedureFunction.java:334) at com.appiancorp.ps.function.ExecuteStoredProcedureFunction.executeStoredProcedure(ExecuteStoredProcedureFunction.java:75) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessor..."

My store prcedure runs from oracle and it looks like the below:

create or replace PROCEDURE test1(cursort OUT SYS_REFCURSOR)
AS
BEGIN

OPEN cursort FOR
SELECT CLU_TRANS_ID,CLU_TRANS_STS_ID from CLU_TRANS
where ROWNUM <10 ;
END;

Could someone please assist on the this.

  Discussion posts and replies are publicly visible

Parents Reply Children