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)ASBEGIN
OPEN cursort FOR SELECT CLU_TRANS_ID,CLU_TRANS_STS_ID from CLU_TRANSwhere ROWNUM <10 ; END;
Could someone please assist on the this.
Discussion posts and replies are publicly visible