How to get OUTPUT from JDBC Action JDBC step after executing a Stored Procedure in a Flow Designer?

Akhila11 · ‎09-05-2022

We have a stored procedure which we are executing through JDBC action in flow designer.

Does anybody know how we can get the output in the next step?

I don't see the ResultSet object in the data picker which we usually get for actions which have select statements.

I am using below statement to execute the stored Procedure:

ecex <stored procedure> '<input>',OUTPUT

This is an urgent requirement, please help.

Tuna · ‎03-14-2023

May I ask how your SP call from the JDBC step does look like? And which type of DB is the SP in? Is it Oracle, MS SQL, etc.? I am trying to figure out to call an Oracle SP from a Flow Action Step but it's not working.

Akhila11 · ‎03-14-2023

Hi Tuna,

The SP was residing in Netezza DB. I don't have access the access to the system anymore to show you how we configured it. Maybe you can share more details about what is not working I can try helping you out.

MundoHC · ‎10-27-2023

Hi @Akhila11, I want to ask you the same question as @Tuna, how did you execute the stored procedure from the flow designer step? I have tried to do it, but I have had no success.

Tuna · ‎10-30-2023

It's simply not possible. We've talked to the ServiceNow support and tried every possible way we could think of, but there is nothing that enables you to execute a stored procedure from a Flow directly. Very disappointing! With classic Workflows it is possible but not with Flows...