Oracle: ERROR com.appiancorp.ps.function.ExecuteStoredProcedureFunction - Error executing

Hello,

The following error appears when I try to excecute the function fn!executestoredprocedure()

LOG TomCat: ERROR com.appiancorp.ps.function.ExecuteStoredProcedureFunction - Error executing

What can be happening?

It would be helpful if you could share your stored procedure call here. Also, are you able to execute the stored procedure directly in the DB?

It could be that you are not including the schema in the call, etc.

Inspiring

Yes, it is possible to execute the SP from the Database and the JDCB is correct, we can query the entities.

fn!executestoredprocedure(
dataSourceName: "jdbc/Hipotecario",
procedureName: "SP_NUMSEQUENTIAL_03"
)

Procedure has no inputs!

I'm not sure where "Hipotecario" is coming from in this case, per your error message.

Is the same error presented when you execute this in an expression rule (to directly see the results)?

Also, I would suggest for the procedureName input, utilizing "schema.procedure" instead of just "procedure".

Sign up